# 176|SQL – Precision Plane Data Presentation

**URL:** <https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640>\
**Category:** Challenges\
**Tags:** managerial, sql, intro, planes\
**Created:** [April 30, 2024, 12:45am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640 "2024-04-30T00:45:43Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![Henry\_Chen](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/henry_chen/32/6979_2.png) [@Henry\_Chen](https://www.techhub.training/u/Henry_Chen)\
**Post date:** [February 23, 2025, 6:28am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/21 "2025-02-23T06:28:53Z")

</div>

Time to complete 10:

1. SELECT first\_name, last\_name  
FROM Employee  
;

2. 

SELECT vendor\_id, company\_name, phone\_number  
FROM Vendor;

3.SELECT inventory\_name, std\_expenditure\_freq AS order\_frequency  
FROM Inventory;

4.SELECT emp\_role\_description  
FROM EmployeeRole  
WHERE TRIM(emp\_role\_description) ;

---

<div class="post-metadata">

**Author:** ![Rylee\_Schriever](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/rylee_schriever/32/6914_2.png) [@Rylee\_Schriever](https://www.techhub.training/u/Rylee_Schriever)\
**Post date:** [February 24, 2025, 12:48am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/23 "2025-02-24T00:48:59Z")

</div>

Time to complete: 10  
Difficulty: easy

1. SELECT \*  
FROM Employee;
2. SELECT v.vendor\_id, v.company\_name, v.phone\_number  
FROM Vendor AS v;
3. SELECT i.inventory\_name, i.std\_expenditure\_freq AS order\_frequency  
FROM Inventory AS i;
4. SELECT er.emp\_role\_description  
FROM EmployeeRole AS er;

---

<div class="post-metadata">

**Author:** ![Cannon\_Hamilton](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/cannon_hamilton/32/7390_2.png) [@Cannon\_Hamilton](https://www.techhub.training/u/Cannon_Hamilton)\
**Post date:** [February 24, 2025, 1:35am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/24 "2025-02-24T01:35:51Z")

</div>

Solutions:  
Q1: SELECT \*  
FROM Employee;

Q2: SELECT vendor\_id, company\_name, phone\_number  
FROM Vendor;

Q3: SELECT inventory\_name, std\_expenditure\_freq AS order\_frequency  
FROM Inventory;

Q4: SELECT emp\_role\_description  
FROM EmployeeRole;

---

<div class="post-metadata">

**Author:** ![Nate\_Hansen](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/nate_hansen/32/7389_2.png) [@Nate\_Hansen](https://www.techhub.training/u/Nate_Hansen)\
**Post date:** [February 24, 2025, 2:42am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/25 "2025-02-24T02:42:19Z")

</div>

Time to complete: 15min  
Rating: Easy  
Comments: Learning is fun

1. SELECT \*  
FROM Employee;

2. SELECT Vendor\_id, company\_name, phone\_number  
FROM Vendor;

3. SELECT inventory\_name, std\_expenditure\_freq as order\_frequency  
FROM Inventory;

4. Select emp\_role\_description  
FROM EmployeeRole;

---

<div class="post-metadata">

**Author:** ![Gavin\_Ross](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/gavin_ross/32/7071_2.png) [@Gavin\_Ross](https://www.techhub.training/u/Gavin_Ross)\
**Post date:** [February 24, 2025, 5:40am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/26 "2025-02-24T05:40:01Z")

</div>

Time to complete: 10 minutes  
Difficulty: Easy  
Solution:

1. SELECT \*  
FROM Employee;

2. SELECT vendor\_id, company\_name, phone\_number  
FROM Vendor;

3. SELECT inventory\_name, std\_expenditure\_freq AS order\_frequency  
FROM Inventory;

4. SELECT emp\_role\_description  
FROM EmployeeRole;

---

<div class="post-metadata">

**Author:** ![Katie\_Kim](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/katie_kim/32/7392_2.png) [@Katie\_Kim](https://www.techhub.training/u/Katie_Kim)\
**Post date:** [February 24, 2025, 7:11am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/27 "2025-02-24T07:11:55Z")

</div>

Time to complete: 10 Minutes  
Difficulty: Easy

Solutions:

1. SELECT \* FROM Employee;

2. SELECT vendor\_id, company\_name, phone\_number FROM Vendor;

3. SELECT inventory\_name, std\_expenditure\_freq as order\_frequency FROM Inventory;

4. Select emp\_role\_description FROM EmployeeRole;

---

<div class="post-metadata">

**Author:** ![Lilia\_Fisher](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/lilia_fisher/32/7394_2.png) [@Lilia\_Fisher](https://www.techhub.training/u/Lilia_Fisher)\
**Post date:** [February 24, 2025, 5:10pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/28 "2025-02-24T17:10:36Z")

</div>

Time to complete: 10  
Rating: Beginner  
Basic challenge good for getting my feet wet.

1. SELECT \*  
FROM Employee;
2. SELECT vendor\_id, company\_name, phone\_number  
FROM Vendor;
3. SELECT inventory\_name, std\_expenditure\_freq AS order\_frequency  
FROM Inventory;
4. SELECT emp\_role\_description  
FROM EmployeeRole;

---

<div class="post-metadata">

**Author:** ![Faith\_Bangerter](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/faith_bangerter/32/7395_2.png) [@Faith\_Bangerter](https://www.techhub.training/u/Faith_Bangerter)\
**Post date:** [February 24, 2025, 6:22pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/29 "2025-02-24T18:22:20Z")

</div>

Time to Complete: 10 minutes  
Difficulty: Easy  
Solution:  
1: SELECT \*  
FROM Employee;  
2: SELECT vendor\_id, company\_name, phone\_number  
FROM Vendor;  
3: SELECT inventory\_name, std\_expenditure\_freq AS order\_frequency  
FROM Inventory;  
4: SELECT emp\_role\_description  
FROM EmployeeRole;

---

<div class="post-metadata">

**Author:** ![Jacob\_Sumsion](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/jacob_sumsion/32/7396_2.png) [@Jacob\_Sumsion](https://www.techhub.training/u/Jacob_Sumsion)\
**Post date:** [February 24, 2025, 6:37pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/30 "2025-02-24T18:37:01Z")

</div>

Time to Complete: 10 mins  
Difficuty: Easy

Solution:  
Q1  
Select \*  
From Employee

Q2  
Select vendor\_id, company\_name, phone\_number  
FROM vendor

Q3  
Select inventory\_name, std\_expenditure\_freq AS order\_frequency  
FROM Inventory

Q4  
Select emp\_role\_description  
FROM EmployeeRole

---

<div class="post-metadata">

**Author:** ![Ian\_Bonine](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/ian_bonine/32/6911_2.png) [@Ian\_Bonine](https://www.techhub.training/u/Ian_Bonine)\
**Post date:** [February 24, 2025, 6:52pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/31 "2025-02-24T18:52:09Z")

</div>

Time: 10 mins  
Difficulty: Easy  
Solution:  
1.  
SELECT \*  
FROM Employee  
2.  
SELECT vendor\_id, company\_name, phone\_number  
FROM Vendor  
3.  
SELECT Inventory.inventory\_name, Inventory.std\_expenditure\_freq AS order\_frequency  
FROM Inventory  
4.  
SELECT emp\_role\_description  
FROM EmployeeRole

---

<div class="post-metadata">

**Author:** ![Connor\_Smith](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/connor_smith/32/7397_2.png) [@Connor\_Smith](https://www.techhub.training/u/Connor_Smith)\
**Post date:** [February 24, 2025, 8:42pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/32 "2025-02-24T20:42:52Z")

</div>

Time to Complete: 8 Mins  
Difficulty: Easy  
Solution:  
1.SELECT\*  
From Employee;  
2.SELECT vendor\_id, company\_name, phone\_number  
From Vendor;  
3.SELECT inventory\_name, std\_expenditure\_freq as order\_frequency  
From Inventory;  
4.SELECT emp\_role\_description  
From EmployeeRole;

---

<div class="post-metadata">

**Author:** ![Katelyn\_Hamilton](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/katelyn_hamilton/32/7398_2.png) [@Katelyn\_Hamilton](https://www.techhub.training/u/Katelyn_Hamilton)\
**Post date:** [February 24, 2025, 9:04pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/33 "2025-02-24T21:04:29Z")

</div>

Time to complete: 10 minutes  
Difficulty: Easy  
Solution:

1. SELECT \*  
FROM Employee;
2. SELECT vendor\_id, company\_name, phone\_number  
FROM Vendor;
3. SELECT inventory\_name, std\_expenditure\_freq AS order\_frequency  
FROM Inventory;
4. SELECT emp\_role\_description  
FROM EmployeeRole;

---

<div class="post-metadata">

**Author:** ![Andrew\_Wells](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/andrew_wells/32/7399_2.png) [@Andrew\_Wells](https://www.techhub.training/u/Andrew_Wells)\
**Post date:** [February 24, 2025, 9:34pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/34 "2025-02-24T21:34:34Z")

</div>

Time to complete: 10 minutes  
Difficulty: Easy  
Solutions:  
1.  
SELECT \*  
FROM Employee;  
2.  
SELECT vendor\_id, company\_name, phone\_number  
FROM Vendor;  
3.  
SELECT inventory\_name, std\_expenditure\_frequency AS order\_frequency  
FROM Inventory;  
4.  
SELECT emp\_role\_description  
FROM EmployeeRole;

---

<div class="post-metadata">

**Author:** ![Rachel\_Lopez](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/rachel_lopez/32/7388_2.png) [@Rachel\_Lopez](https://www.techhub.training/u/Rachel_Lopez)\
**Post date:** [February 24, 2025, 10:13pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/35 "2025-02-24T22:13:37Z")

</div>

Time to Complete: 8 minutes  
Rating: Easy  
Comments: Easy and a good review

Q1: SELECT \*  
FROM Employee;

Q2: SELECT vendor\_id, company\_name, phone\_number  
FROM Vendor;

Q3: SELECT inventory\_name, std\_expenditure\_freq AS order\_frequency  
FROM Inventory;

Q4: SELECT emp\_role\_description  
FROM EmployeeRole;

---

<div class="post-metadata">

**Author:** ![Molly\_Pratt](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/molly_pratt/32/7400_2.png) [@Molly\_Pratt](https://www.techhub.training/u/Molly_Pratt)\
**Post date:** [February 24, 2025, 10:18pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/36 "2025-02-24T22:18:41Z")

</div>

Time to Complete: 5  
Rating: Easy  
Comments: Good intro to using SQL in Access

1: SELECT \*  
FROM Employee;  
2: SELECT vendor\_id, company\_name, phone\_number  
FROM Vendor;  
3. SELECT inventory\_name, std\_expenditure\_freq AS order\_frequency  
FROM inventory;  
4. SELECT emp\_role\_description  
FROM EmployeeRole;

---

<div class="post-metadata">

**Author:** ![Jane\_Cai](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/jane_cai/32/7278_2.png) [@Jane\_Cai](https://www.techhub.training/u/Jane_Cai)\
**Post date:** [February 24, 2025, 10:27pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/37 "2025-02-24T22:27:15Z")

</div>

Time to complete: 7 minutes  
Difficulty: Easy

Solution:  
Question 1:  
SELECT \*  
FROM Employee;

Question 2:  
SELECT vendor\_id, company\_name, phone\_number  
FROM Vendor;

Question 3:  
SELECT inventory\_name, std\_expenditure\_freq AS order\_frequency  
FROM Inventory;

Question 4:  
SELECT emp\_role\_description  
FROM EmployeeRole;

---

<div class="post-metadata">

**Author:** ![Tyson\_Yee](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/tyson_yee/32/7401_2.png) [@Tyson\_Yee](https://www.techhub.training/u/Tyson_Yee)\
**Post date:** [February 24, 2025, 10:49pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/38 "2025-02-24T22:49:12Z")

</div>

Time to complete: 10 minutes  
Rating: Beginner

1. SELECT emp\_role\_description  
FROM EmployeeRole;

2. SELECT vendor\_id, company\_name, phone\_number  
FROM Vendor;

3. SELECT inventory\_name, std\_expenditure\_freq AS order\_frequency  
FROM Inventory;

4. SELECT emp\_role\_description  
FROM EmployeeRole;

---

<div class="post-metadata">

**Author:** ![Hailey\_Smith](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/hailey_smith/32/7077_2.png) [@Hailey\_Smith](https://www.techhub.training/u/Hailey_Smith)\
**Post date:** [February 24, 2025, 11:24pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/39 "2025-02-24T23:24:04Z")

</div>

Time to complete: 10 minutes  
Rating: Beginner  
1:  
SELECT \*  
FROM Employee;  
2:  
SELECT vendor\_id, company\_name, phone\_number  
FROM Vendor;  
3:  
SELECT inventory\_name, std\_expenditure\_freq AS order\_frequency  
FROM Inventory;  
4:  
SELECT emp\_role\_description  
FROM EmployeeRole;

---

<div class="post-metadata">

**Author:** ![Chris\_Sosa](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/chris_sosa/32/7375_2.png) [@Chris\_Sosa](https://www.techhub.training/u/Chris_Sosa)\
**Post date:** [February 24, 2025, 11:36pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/40 "2025-02-24T23:36:29Z")

</div>

Time to Complete: 10 minutes  
Difficulty: Easy

1. SELECT \*  
FROM Employee;  
2.SELECT v.vendor\_id, v.company\_name, v.phone\_number  
FROM vendor as v;  
3.SELECT i.inventory\_name, i.std\_expenditure\_freq as order\_frequency  
FROM Inventory as i;  
4.SELECT er.emp\_role\_description  
FROM EmployeeRole as er;

---

<div class="post-metadata">

**Author:** ![Joshua\_Folau](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/joshua_folau/32/7402_2.png) [@Joshua\_Folau](https://www.techhub.training/u/Joshua_Folau)\
**Post date:** [February 24, 2025, 11:43pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/41 "2025-02-24T23:43:29Z")

</div>

Time to complete: 8 minutes  
Rating: Beginning  
Solution:

Q1:  
SELECT \*  
FROM Employee;

Q2:  
SELECT vendor\_id, company\_name, phone\_number  
FROM Vendor;

Q3:  
SELECT inventory\_name, std\_expenditure\_freq AS order\_frequency  
FROM Inventory;

Q4:  
SELECT emp\_role\_description  
FROM EmployeeRole;

[Previous page](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640.md?page=1)

[Next page](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640.md?page=3)