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

<div class="post-metadata">

**Author:** ![Sterling\_Lane](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/sterling_lane/32/399_2.png) [@Sterling\_Lane](https://www.techhub.training/u/Sterling_Lane)\
**Post date:** [April 30, 2024, 12:45am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/1 "2024-04-30T00:45:44Z")

</div>

_BYU Student Author_: @Sterling_Lane  
_Reviewers_: @Andrew_Wilson, @Marta_Ellsworth  
_Estimated Time to Solve:_ 10 Minutes

This is an intro challenge that is part of the [SQL Learning Path](https://www.techhub.training/t/sql-learning-path/2630).

We provide the solution to this challenge using:

- SQL

Need a program? Click [here](https://www.techhub.training/t/information-about-software-used-on-techhub-training/138).

**Overview**  
Welcome to your first day at the Precision Plane Parts accounts payable department! Our company is dedicated to helping the aerospace industry build the safest aircraft possible by providing and delivering high quality equipment. Your role here is to help us in that endeavor by maintaining our expenditures database so we can continue to maintain our inventory and continue to keep good relationships with our vendors. For your first day, you are tasked with getting familiar with our main database. Download the attached Access database and get started!

**Instructions**  
Run each of the queries below and save your results as separate queries in Access. To create a new query, first click the “Query Design” button in the Create pane in Access. From here, switch the view to the SQL view by selecting the “SQL” view button in the top left or bottom right corner of the page. To save your query, simply hit “ctrl + s” to open a dialog box asking you to name your query. This will save each of your queries next to the tables in your database.

1. Who are the employees that work with us? Write a query displaying all columns from the Employee table.  
a. Select all the columns from the Employee table
2. Who are the vendors that buy from us, and how do we contact them? Write a query displaying the vendor id, company name, and company phone number from the Vendor table.  
a. Select the vendor\_id, company\_name, and phone\_number columns from the Vendor table.
3. How frequently do we sell our inventory items? Write a query showing the inventory name and standard expenditure frequency for each item in the Inventory table.  
a. Select the inventory\_name and std\_expenditure\_freq columns from the Inventory table.  
b. Rename the std\_expenditure\_freq column to order\_frequency
4. What types of roles do our employees have? Write a query showing the list of employee roles in our Accounts Payable department.  
a. Select the emp\_role\_description column from the EmployeeRole table.

 ![Challenge176_Image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/8/8ba8e766cd1c81b166be7820cf828dc6c1d12d26.png)

**Data Files**

- [Challenge176\_Data.accdb](https://byu.box.com/shared/static/5auev1fy6lsqo0dxmhonpe1an9z5ids9)

> **Suggestions and Hints**
>
> - To select all the columns in a table, use the ‘\*’ key word (SELECT \* FROM Table)
> - All of the requested queries can be done by using only the SELECT and FROM statements.

**Solution**

> **Solution Code**
>
> Query 1
> 
> ```auto
> SELECT * 
> FROM Employee; 
> 
> ```
> 
> Query 2
> 
> ```auto
> SELECT vendor_id, company_name, phone_number 
> FROM Vendor; 
> 
> ```
> 
> Query 3
> 
> ```auto
> SELECT inventory_name, std_expenditure_freq AS order_frequency 
> FROM Inventory; 
> 
> ```
> 
> Query 4
> 
> ```auto
> SELECT emp_role_description 
> FROM EmployeeRole; 
> 
> ```

[Challenge176\_Solution.accdb](https://byu.box.com/shared/static/pnykp93o4nv3v3d1p88u4bt5soiprgdt)  
_Solution Video:_ [Challenge 176|SQL – Precision Plane Data Presentation](https://youtu.be/sHJbOxP3jFE)

---

<div class="post-metadata">

**Author:** ![qt\_915](https://avatars.discourse-cdn.com/v4/letter/q/ed8c4c/32.png) [@qt\_915](https://www.techhub.training/u/qt_915)\
**Post date:** [June 28, 2024, 6:36am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/2 "2024-06-28T06:36:31Z")

</div>

Solution:  
Q1  
SELECT employee\_id, first\_name, last\_name, employee\_role\_id  
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:** ![Gabrielle\_Johnson](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/gabrielle_johnson/32/7371_2.png) [@Gabrielle\_Johnson](https://www.techhub.training/u/Gabrielle_Johnson)\
**Post date:** [February 20, 2025, 7:30pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/3 "2025-02-20T19:30:52Z")

</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:** ![Porter\_Rich](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/porter_rich/32/7372_2.png) [@Porter\_Rich](https://www.techhub.training/u/Porter_Rich)\
**Post date:** [February 20, 2025, 8:49pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/4 "2025-02-20T20:49:55Z")

</div>

Time to Complete: 10 mins  
Rating: Beginner  
Solutions:

1. SELECT \*  
FROM Employee;

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

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

4. SELECT emp\_role\_description  
FROM EmployeeRole;

---

<div class="post-metadata">

**Author:** ![Meadow\_Mitchell](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/meadow_mitchell/32/7366_2.png) [@Meadow\_Mitchell](https://www.techhub.training/u/Meadow_Mitchell)\
**Post date:** [February 20, 2025, 9:25pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/5 "2025-02-20T21:25:57Z")

</div>

CHALLENGE 176  
Time to complete: 7 minutes  
Difficulty: Beginner  
Notes: Enjoyed the challenge!

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:** ![ShortyoShire](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/shortyoshire/32/7289_2.png) [@ShortyoShire](https://www.techhub.training/u/ShortyoShire)\
**Post date:** [February 20, 2025, 9:30pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/6 "2025-02-20T21:30:10Z")

</div>

Time to Complete: 5 mins  
Rating: Beginner  
Comments: Definitely a good place to start for those new to SQL  
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:** ![Madelyn\_Boulton](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/madelyn_boulton/32/7288_2.png) [@Madelyn\_Boulton](https://www.techhub.training/u/Madelyn_Boulton)\
**Post date:** [February 20, 2025, 10:16pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/7 "2025-02-20T22:16:34Z")

</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:** ![Kathryn\_Thompson\_Whi](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/kathryn_thompson_whi/32/7373_2.png) [@Kathryn\_Thompson\_Whi](https://www.techhub.training/u/Kathryn_Thompson_Whi)\
**Post date:** [February 21, 2025, 5:16pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/8 "2025-02-21T17:16:06Z")

</div>

Time: 8 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:** ![Aaron\_Greenwood](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/aaron_greenwood/32/7376_2.png) [@Aaron\_Greenwood](https://www.techhub.training/u/Aaron_Greenwood)\
**Post date:** [February 22, 2025, 4:21am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/9 "2025-02-22T04:21:48Z")

</div>

Time to complete: 5-10 minutes  
Difficulty: Easy  
Solution:

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:** ![Miles\_Maynes](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/miles_maynes/32/7377_2.png) [@Miles\_Maynes](https://www.techhub.training/u/Miles_Maynes)\
**Post date:** [February 22, 2025, 7:08am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/10 "2025-02-22T07:08:32Z")

</div>

Time to complete: 5 minutes  
Rating:Beginner  
Solution:

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

---

<div class="post-metadata">

**Author:** ![Emily\_Cook](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/emily_cook/32/7379_2.png) [@Emily\_Cook](https://www.techhub.training/u/Emily_Cook)\
**Post date:** [February 22, 2025, 4:16pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/11 "2025-02-22T16:16:58Z")

</div>

Time to Complete: 5-10 Minutes  
Difficulty: Easy  
Solution:

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

---

<div class="post-metadata">

**Author:** ![Joshua\_Anderson](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/joshua_anderson/32/7380_2.png) [@Joshua\_Anderson](https://www.techhub.training/u/Joshua_Anderson)\
**Post date:** [February 22, 2025, 4:39pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/12 "2025-02-22T16:39:27Z")

</div>

Time to Complete: 10 Minutes  
Difficulty: Easy

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:** ![Nolan\_Brewer](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/nolan_brewer/32/7020_2.png) [@Nolan\_Brewer](https://www.techhub.training/u/Nolan_Brewer)\
**Post date:** [February 22, 2025, 4:42pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/13 "2025-02-22T16:42:05Z")

</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:** ![Lucas\_Argente](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/lucas_argente/32/7381_2.png) [@Lucas\_Argente](https://www.techhub.training/u/Lucas_Argente)\
**Post date:** [February 22, 2025, 6:48pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/14 "2025-02-22T18:48:17Z")

</div>

Time to complete: 10 Minutes  
Difficulty: 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:** ![Cooper\_Wise](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/cooper_wise/32/7383_2.png) [@Cooper\_Wise](https://www.techhub.training/u/Cooper_Wise)\
**Post date:** [February 22, 2025, 10:51pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/15 "2025-02-22T22:51:02Z")

</div>

Time to complete: 10 Minutes  
Difficulty: Easy  
Solution:  
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 emp\_role\_description  
FROM EmployeeRole

---

<div class="post-metadata">

**Author:** ![McKenna\_Hall](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/mckenna_hall/32/7378_2.png) [@McKenna\_Hall](https://www.techhub.training/u/McKenna_Hall)\
**Post date:** [February 22, 2025, 11:31pm UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/16 "2025-02-22T23:31:53Z")

</div>

Time to complete: 7 minutes  
Rating: Easy  
Solution:

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:** ![Cragun\_Bastian](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/cragun_bastian/32/7385_2.png) [@Cragun\_Bastian](https://www.techhub.training/u/Cragun_Bastian)\
**Post date:** [February 23, 2025, 2:40am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/17 "2025-02-23T02:40:34Z")

</div>

Time to Complete: 15 min  
Rating: Easy

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:** ![Meilan\_Rhoton](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/meilan_rhoton/32/7386_2.png) [@Meilan\_Rhoton](https://www.techhub.training/u/Meilan_Rhoton)\
**Post date:** [February 23, 2025, 3:23am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/18 "2025-02-23T03:23:50Z")

</div>

Time to complete: 6 minutes  
Rating: Easy  
Solution:

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 emp\_role\_description  
FROM EmployeeRole;

---

<div class="post-metadata">

**Author:** ![Amanda\_Garton](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/amanda_garton/32/7384_2.png) [@Amanda\_Garton](https://www.techhub.training/u/Amanda_Garton)\
**Post date:** [February 23, 2025, 3:26am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/19 "2025-02-23T03:26:48Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Shane\_Hawkins](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/shane_hawkins/32/6951_2.png) [@Shane\_Hawkins](https://www.techhub.training/u/Shane_Hawkins)\
**Post date:** [February 23, 2025, 3:51am UTC](https://www.techhub.training/t/176-sql-precision-plane-data-presentation/2640/20 "2025-02-23T03:51:56Z")

</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

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