176|SQL – Precision Plane Data Presentation

[Sydney_Clove]

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;

[Colter_Sill]

Time to Complete: 10 mins
Difficulty: Beginner
Answer:

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;

[Josh_Tanner]

Time to Complete: 5 minutes
Difficulty: Easy
Comments: It was a fun challange!
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

[Kameron_K_Sakamoto]

Time to Complete: 12min
Difficulty: Beginner
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;

[Nolan_Ward]

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

[Lindsay_Shields]

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;

[Thomas_Sanders]

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;

[Sophie_Dong]

Time to Complete: 10 minutes
Difficulty: Beginner
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;

[Zachary_Kuta]

Time: 5 minutes
Rating: Beginner
Solution:
SQL 1:
SELECT emp_role_description
FROM EmployeeRole;
SQL 2:
SELECT vendor_id, company_name, phone_number 
from Vendor;
SQL 3:
SELECT inventory_name, std_expenditure_freq AS order_frequency
FROM Inventory;
SQL 4:
SELECT emp_role_description
FROM EmployeeRole;

[Tyler_Brickey]

Time to Complete: 10 minutes
Difficulty: Beginner
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;

[Genevieve_Nichols]

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;

[Travis_Walker]

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

[jacksonbutler10]

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;

[Andrew_Benson]

Time to Complete: 5 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 DISTINCT emp_role_description
FROM EmployeeRole

[Clyn_Hansen]

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 v;
3. SELECT inventory_name, std_expenditure_freq as order_frequency
   FROM Inventory;
4. SELECT emp_role_description
   FROM EmployeeRole;

[Liam_Smith]

1. SELECT *
   FROM Employee AS e

2. SELECT vendor_id, company_name, phone_number
   FROM Vendor AS v

3. SELECT inventory_name, std_expenditure_freq AS order_frequency
   FROM Vendor

4. SELECT emp_role_description
   FROM EmployeeRole

[Connor_Larson]

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 AS order_frequency
   FROM Inventory;

4. SELECT emp_role_description
   FROM EmployeeRole;

[Layton_Allred]

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;

[James_Lloyd]

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;

[Samantha_Cassell]

Query 1
SELECT *
From Employee;

Query 2
SELECT vendor_id, company_name, phone_number
From Vendor;

Query 3
SELECT inventory_id, std_expenditure_freq AS order_frequency
From Inventory;

Query 4
SELECT emp_role_description
From EmployeeRole;