176|SQL – Precision Plane Data Presentation

[Nick_Price]

Time to Complete: 10 Minutes
Rating: Beginner

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;

[Finlay_Lofthouse]

Time: 5 minutes
Difficulty: Easy
Solution:
Q1
SELECT *
FROM Employee
Q2
SELECT v.vendor_id, v.company_name, v.phone_number
FROM Vendor AS v;
Q3
SELECT i.inventory_name, i.std_expenditure_freq AS order_frequency
FROM Inventory AS i;
Q4
SELECT e.emp_role_description
FROM EmployeeRole AS e;

[Braden_Jones]

Time to complete: 10 mins
Difficulty: Easy
Solutions:

1. SELECT *
   FROM Employee
   ORDER BY employee_id ASC;

2. SELECT vendor_id, company_name, phone_number
   FROM vendor
   ORDER BY vendor_id ASC;

3. SELECT inventory_name, std_expenditure_freq AS order_frequency
   FROM inventory

4. SELECT emp_role_description
   FROM EmployeeRole
   ORDER BY emp_role_description ASC;

[Elisabeth_Ware]

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;

[Annecy_Hansen]

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;

[Tessa_Staley]

Time to complete: 10 min
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;

[Tyson_Burrup]

@Sterling_Lane

emp_role_description

Time to Complete: 10 Minutes
Difficulty Easy
Solution:
Query 1
SELECT *
From Employee;
Query 2
SELECT vendor_id, company_name, phone_number
From Vendor;
Query 3
SELECT inventory_name, std_expenditure_freq AS order_frequency
FROM Inventory;
Query 4
SELECT emp_role_description
from EmployeeRole;

[Jared_Divelbiss]

Time to Complete: 10
Difficulty: Beginner
Solution:
SELECT *
FROM EMPLOYEE;

SELECT vendor_id, company_name, phone_number
FROM Vendor;

SELECT inventory_name, std_expenditure_freq
FROM Inventory;

SELECT emp_role_description AS Expr1
FROM EmployeeRole;

[Alejandro_Sanchez]

Time to complete: 7 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 AS order_frequency
FROM Inventory;
4
SELECT emp_role_description
FROM EmployeeRole;

[Ella_Gatherum]

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

[Sam_Drummond]

Time: 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;

[Tyler_Whitney]

Time to Complete: 10 mins
Rating: Beginner
Soultion:

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

[Carter_McQuivey]

Time: 5 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;

[Dayna_Ranta]

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;

[Anna_Montgomery]

Time: 10 min.
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;

[Adeline_Christensen]

Time to Complete: 10 minutes
Level: Beginner

1. SELECT *
   FROM Employee

2. SELECT vendor_id, company_name, phone_name
   FROM Vendor

3. SELECT inventory_name, std_expenditure_freq As order_frequency
   FROM Inventory

4. SELECT emp_role_description
   FROM EmployeeRole

[Tyler_Loose]

Time to complete: 10
Difficulty: 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

[Emma_Fromm]

Time to Complete: 10 minutes
Rating: Beginner

1. Query 1 Solution:
   SELECT *
   FROM Employee;
2. Query 2 Solution:
   SELECT vendor_id, company_name, phone_number
   FROM Vendor;
3. Query 3 Solution:
   SELECT inventory_name, std_expenditure_freq AS order_frequency
   FROM Inventory;
4. Query 4 Solution:
   SELECT emp_role_description
   FROM EmployeeRole;

[Jackson_Bond]

Time to complete: 8 minutes
Level of difficulty: easy
I liked how it was helpful to begin to understand the basics of SQL

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;

[Collin_Simon]

Time to complete: 10 minutes
Rating: Easy
Definitely a beginner practice of SQL, really easy after the SQL tutorial we received last week.

Solution:
SELECT *
From Employee

SELECT vendor_id, company_name, phone_number
FROM Vendor

SELECT inventory_name, std_expenditure_freq AS order_frequency
From Inventory

SELECT emp_role_description
From EmployeeRole