Please use the Pine Valley Furniture sample database attached

Query $1$: Write an SQL query to list each customer who has bought computer

desks and the number of units sold to each customer.

Query $2$: Write an SQL query to list each customer who bought at least one

product that belongs to product line Basic in March $2015.$

Query $3$: List, in alphabetical order, the names of all employees $($managers$)$

who are now managing people with skill ID BS$12$; list each manager's name

only once, even if that manager manages several people with this skill.

Query $4$: Display the salesperson name, product finish, and total quantity sold

$($label as TotSales$)$ for each finish by each salesperson.

Query $5$: Write a query to list the number of products produced in each work

center $($label as TotalProducts$).$ If a work center does not produce any

products, display the result with a total of $0.$

Query $6$: Write an SQL query to produce a list of all the products $($i$.$e$.,$ product

description$)$ and the number of times each product has been ordered.

Query $7$: Display the customer ID$,$ name, and order ID for all customer orders.

For those customers who do not have any orders, include them in the display

once.

Query $8$: Display the EmployeelD and EmployeeName for those employees

who do not possess the skill Router. Display the results in order by

EmployeeName.