SQL Queries

1. SELECT Prod_SKU, Prod_Descript, Prod_Type, Prod_Base, Prod_Category, Prod_Price

2. SELECT Emp_Fname, Emp_Lname, Emp_Email

3. SELECT Emp_Fname, Emp_Lname, Emp_Phone, Emp_Title, Dept_Num

4. SELECT e.Emp_Num, e.Emp_Lname, e.Emp_Fname, sh.Sal_From, sh.Sal_End,

5. SELECT DISTINCT e.Cust_Fname, e.Cust_Lname, e.Cust_street, e.Cust_city, e.Cust_state, e.Cust_ZIP

6. SELECT e.Emp_Num, e.Emp_Lname, e.Email, e.Emp_Title, d.Dept_Name

7. SELECT b.Brand_Name, COUNT(p.Prod_SKU)

8. SELECT Prod_Category, COUNT(Prod_SKU)

9. SELECT prod_base, prod_type, COUNT(Prod_SKU)

10. SELECT Brand_ID, SUM(Prod_QOH)

11. SELECT b.Brand_ID, b.Brand_Name, ROUND(AVG(p.Prod_Price))

12. SELECT dept_num, MAX(Emp_Hiredate)

13. SELECT e.Emp_Num, e.Emp_Fname, e.Emp_Lname, MAX(sh.Sal_Amount)

14. SELECT c.Cust_Code, c.Cust_Fname, c.Cust_Lname, SUM(i.Inv_Total)