practice_questions_wk2.sql

--Practice Questions Week 2 (Answers posted before week 3)

--1. Write a query to get Product name and quantity per unit.



--2. Write a query to get current Product list (Product ID and name).



--3. Write a query to get discontinued Product list (Product ID and name).



--4. Write a query to get most expense and least expensive Product list (name and unit price).




--5. Write a query to get Product list (id, name, unit price) where current products cost less than $20.




--6. Write a query to get Product list (id, name, unit price) where products cost between $15 and $25.




--7. Write a query to get Product list (name, unit price) of above average price.



--8. Write a query to get Product list (name, unit price) of ten most expensive products.



--9. Write a query to count current and discontinued products.



--10. Write a query to get Product list (name, units on order , units in stock) of stock is less than the quantity on order.