176|SQL – Precision Plane Data Presentation

[Preston_Dudley]

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;

[Charlotte_Owsley]

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
;

[Kylie_Eaquinto]

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;

[William_Cole]

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

[Austin_Smith]

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

[Kate_Munger]

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;

[Cady_Eaton]

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

[Spencer_McArthur]

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;

[Zen_Villondo]

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

[Michelle_Black]

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;

[Tyler_Herget]

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

[Charlie_Canady]

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;

[Justin_Day]

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;

[Ashleigh_Layton]

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;

[Josue_Quilantan]

Time to Complete: 5 minutes
Rating: Beginner
Solutions:

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;

[Scott_Johnston]

Time to complete: 10 min
Difficulty: Easy
Solution:

SELECT *
FROM Employee;

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

SELECT i.inventory_name, i.std_expenditure_freq AS order_frequency
FROM Inventory AS i;

SELECT er.emp_role_description
FROM EmployeeRole AS er;

[Katelyn_Pittman]

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;

[Ethan_Benoit]

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;

[Eison_Deng]

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;

[Audrey_Vengesai]

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;