176|SQL – Precision Plane Data Presentation

[Henry_Chen]

Time to complete 10:

1. SELECT first_name, last_name
   FROM Employee
   ;

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
WHERE TRIM(emp_role_description) ;

[Rylee_Schriever]

Time to complete: 10
Difficulty: easy

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;

[Cannon_Hamilton]

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;

[Nate_Hansen]

Time to complete: 15min
Rating: Easy
Comments: Learning is fun

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;

[Gavin_Ross]

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;

[Katie_Kim]

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;

[Lilia_Fisher]

Time to complete: 10
Rating: Beginner
Basic challenge good for getting my feet wet.

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;

[Faith_Bangerter]

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;

[Jacob_Sumsion]

Time to Complete: 10 mins
Difficuty: 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

[Ian_Bonine]

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

[Connor_Smith]

Time to Complete: 8 Mins
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;

[Katelyn_Hamilton]

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;

[Andrew_Wells]

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_frequency AS order_frequency
FROM Inventory;
4.
SELECT emp_role_description
FROM EmployeeRole;

[Rachel_Lopez]

Time to Complete: 8 minutes
Rating: Easy
Comments: Easy and a good review

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;

[Molly_Pratt]

Time to Complete: 5
Rating: Easy
Comments: Good intro to using SQL in Access

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;

[Jane_Cai]

Time to complete: 7 minutes
Difficulty: Easy

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;

[Tyson_Yee]

Time to complete: 10 minutes
Rating: Beginner

1. SELECT emp_role_description
   FROM EmployeeRole;

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;

[Hailey_Smith]

Time to complete: 10 minutes
Rating: Beginner
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;

[Chris_Sosa]

Time to Complete: 10 minutes
Difficulty: Easy

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;

[Joshua_Folau]

Time to complete: 8 minutes
Rating: Beginning
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;