SQL Homework $-$ BADM $323$

Please include a screenshot of your script and your results for each question.

You can attach the screen shots in a word doc or on this document.

Unless I clarify in the problem, you will be using the WPC database.

Chapter $2$ Problems

What departments are listed in the Departments table?

How Many Lockers are there, and what numbers are they?

Chapter $3$ Problems

Take your results from the chapter $2$ problems and sort them both ascending and descending.

Chapter $4$ Problems $($You will use the TYSQL Database for these questions$)$

Show me products not made by Vendor DLL$01.$ I want to see the products, and which vendor makes them.

Which products are at a price point between $4$ and $12$ dollars? $($Hint: Use the Between function$)$

Chapter $5$ Problems

Which employees are named Jones and work in production

Which employees are named Jackson or work in accounting?

Chapter $6$ Problems

Which employee first names start with the letter S$?($Hint: use the Like function$)$

From the Employees table, show me someone with the same initial as your first or last name. If nothing exists, that is ok$,$ s

Chapter $7$ Problems $($You will use the TYSQL Database for these questions$)$

From the OrderItems table, tell me the total price of all RGAN$01$ products sold in order $20007$

Chapter $8$ Problems $($You will use the TYSQL Database for these questions$)$

Using the Soundex function, find a cust$\_$name in the Customers table that sounds like Kids Palace.

Chapter $9$ Problems

What is the average overhead from the Department table? $($Hint: use the AVG$()$ function$)$

Which project has the highest hourly rate? $($Hint: use the MAX $()$ function$)$

Chapter $10$ Problems $($You will use the TYSQL Database for these questions$)$

List all the vendors who have $2$ or more products priced at $4$ or more.

Chapter $11$ Problems

Create a nested query in either the WPC or TYSQL database.

Chapter $12$ Problems

Which students have a full locker? $($Hint: Join the Student and Locker tables$)$

Chapter $13$ Problems

Make a Right Join of STUDENT and LOCKER selecting the StudentName where the LockerType is half

Which Students are not assigned to a locker? $($Hint$,$ Right join LOCKER and STUDENT selecting Student Name and Locker N

Chapter $14$ Problems

Perform a union from the TYSQL database