# 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:** 3

<div class="post-metadata">

**Author:** ![Preston\_Dudley](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/preston_dudley/32/7403_2.png) [@Preston\_Dudley](https://www.techhub.training/u/Preston_Dudley)\
**Post date:** [February 24, 2025, 11:51pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/42 "2025-02-24T23:51:22Z")

</div>

Time to Complete: 10 mins  
Rating: Easy  
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:** ![Charlotte\_Owsley](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/charlotte_owsley/32/6929_2.png) [@Charlotte\_Owsley](https://www.techhub.training/u/Charlotte_Owsley)\
**Post date:** [February 25, 2025, 12:00am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/43 "2025-02-25T00:00:20Z")

</div>

Time to complete: 15 minutes  
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:** ![Kylie\_Eaquinto](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/kylie_eaquinto/32/7404_2.png) [@Kylie\_Eaquinto](https://www.techhub.training/u/Kylie_Eaquinto)\
**Post date:** [February 25, 2025, 12:21am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/44 "2025-02-25T00:21:06Z")

</div>

Time to Complete: 10 minutes  
Difficulty: Easy  
Comments: Good intro to SELECT and FROM  
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:** ![William\_Cole](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/william_cole/32/7181_2.png) [@William\_Cole](https://www.techhub.training/u/William_Cole)\
**Post date:** [February 25, 2025, 1:13am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/45 "2025-02-25T01:13:14Z")

</div>

Time to complete: 10  
Difficulty: Beginner  
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:** ![Austin\_Smith](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/austin_smith/32/7406_2.png) [@Austin\_Smith](https://www.techhub.training/u/Austin_Smith)\
**Post date:** [February 25, 2025, 1:35am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/46 "2025-02-25T01:35:36Z")

</div>

1. SELECT \*  
FROM Employee
2. SELECT Vendor\_ID, Company\_Name, Phone\_Number  
FROMVendor
3. SELECT inventory\_name, std\_expenditure\_freq as order\_frequency  
FROM inventory  
4.SELECT emp\_role\_description  
FROM EmployeeRole

---

<div class="post-metadata">

**Author:** ![Kate\_Munger](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/kate_munger/32/7408_2.png) [@Kate\_Munger](https://www.techhub.training/u/Kate_Munger)\
**Post date:** [February 25, 2025, 1:45am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/47 "2025-02-25T01:45:20Z")

</div>

Time to Complete: 8 minutes  
Difficulty: Beginner  
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:** ![Cady\_Eaton](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/cady_eaton/32/7407_2.png) [@Cady\_Eaton](https://www.techhub.training/u/Cady_Eaton)\
**Post date:** [February 25, 2025, 1:59am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/48 "2025-02-25T01:59:19Z")

</div>

Time to Complete:10 Mins  
Difficulty: Easy  
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:** ![Spencer\_McArthur](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/spencer_mcarthur/32/7409_2.png) [@Spencer\_McArthur](https://www.techhub.training/u/Spencer_McArthur)\
**Post date:** [February 25, 2025, 2:17am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/49 "2025-02-25T02:17:38Z")

</div>

Time to complete: 7  
Ranking: 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:** ![Zen\_Villondo](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/zen_villondo/32/7410_2.png) [@Zen\_Villondo](https://www.techhub.training/u/Zen_Villondo)\
**Post date:** [February 25, 2025, 2:21am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/50 "2025-02-25T02:21:54Z")

</div>

Time to Complete: 10 minutes  
Difficulty: Easy  
Solution: See Below

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:** ![Michelle\_Black](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/michelle_black/32/7034_2.png) [@Michelle\_Black](https://www.techhub.training/u/Michelle_Black)\
**Post date:** [February 25, 2025, 2:45am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/51 "2025-02-25T02:45:11Z")

</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:** ![Tyler\_Herget](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/tyler_herget/32/7411_2.png) [@Tyler\_Herget](https://www.techhub.training/u/Tyler_Herget)\
**Post date:** [February 25, 2025, 2:54am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/52 "2025-02-25T02:54:39Z")

</div>

Time to Complete: 8 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:** ![Charlie\_Canady](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/charlie_canady/32/7412_2.png) [@Charlie\_Canady](https://www.techhub.training/u/Charlie_Canady)\
**Post date:** [February 25, 2025, 3:04am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/53 "2025-02-25T03:04:44Z")

</div>

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:** ![Justin\_Day](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/justin_day/32/7415_2.png) [@Justin\_Day](https://www.techhub.training/u/Justin_Day)\
**Post date:** [February 25, 2025, 3:25am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/54 "2025-02-25T03:25:12Z")

</div>

Time to Complete: 10 minutes  
Difficulty: Easy  
Solution: See Below  
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:** ![Ashleigh\_Layton](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/ashleigh_layton/32/7413_2.png) [@Ashleigh\_Layton](https://www.techhub.training/u/Ashleigh_Layton)\
**Post date:** [February 25, 2025, 3:42am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/55 "2025-02-25T03:42:16Z")

</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:** ![Josue\_Quilantan](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/josue_quilantan/32/7417_2.png) [@Josue\_Quilantan](https://www.techhub.training/u/Josue_Quilantan)\
**Post date:** [February 25, 2025, 4:00am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/56 "2025-02-25T04:00:17Z")

</div>

Time to Complete: 5 minutes  
Rating: Beginner  
Solutions:

1. 

SELECT \*  
FROM Employee;

1. 

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

1. 

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

1. 

SELECT emp\_role\_description  
FROM EmployeeRole;

---

<div class="post-metadata">

**Author:** ![Scott\_Johnston](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/scott_johnston/32/7418_2.png) [@Scott\_Johnston](https://www.techhub.training/u/Scott_Johnston)\
**Post date:** [February 25, 2025, 4:18am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/57 "2025-02-25T04:18:57Z")

</div>

Time to complete: 10 min  
Difficulty: Easy  
Solution:

1. 

SELECT \*  
FROM Employee;

1. 

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

1. 

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

1. 

SELECT er.emp\_role\_description  
FROM EmployeeRole AS er;

---

<div class="post-metadata">

**Author:** ![Katelyn\_Pittman](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/katelyn_pittman/32/7382_2.png) [@Katelyn\_Pittman](https://www.techhub.training/u/Katelyn_Pittman)\
**Post date:** [February 25, 2025, 4:25am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/58 "2025-02-25T04:25:25Z")

</div>

Time to Complete:5  
Difficulty: Easy  
Comments: Lots of fun  
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:** ![Ethan\_Benoit](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/ethan_benoit/32/6912_2.png) [@Ethan\_Benoit](https://www.techhub.training/u/Ethan_Benoit)\
**Post date:** [February 25, 2025, 5:02am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/59 "2025-02-25T05:02:57Z")

</div>

Time to Complete: 10 minutes  
Difficulty: Easy  
See Solution Below:  
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:** ![Eison\_Deng](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/eison_deng/32/6921_2.png) [@Eison\_Deng](https://www.techhub.training/u/Eison_Deng)\
**Post date:** [February 25, 2025, 5:17am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/60 "2025-02-25T05:17:14Z")

</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:** ![Audrey\_Vengesai](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/audrey_vengesai/32/7419_2.png) [@Audrey\_Vengesai](https://www.techhub.training/u/Audrey_Vengesai)\
**Post date:** [February 25, 2025, 5:44am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/61 "2025-02-25T05:44:23Z")

</div>

Time to Complete: 7 minutes  
Difficulty: Easy  
Notes: Enjoyed this challenge  
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;

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

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