Q$1.$ Use the Pine Valley Furniture $($PVF$)$ database for this question. Write a SQL query to display the order number, customer number, order date and items ordered for the customer with ID of $5.$

Q$2.$ Use the Pine Valley Furniture $($PVF$)$ database for this question. Write a SQL query to display each customer ID and name who has bought computer desks, showing total number of orders and the total number of units bought by each customer.

Use the Pine Valley Furniture $($PVF$)$ database for this question. Write a SQL query to display the customer ID$,$ name, state, and order ID for all customer orders. For those customers who do not have any orders, include them in the display once.

Q$3.$ Use the AP database for this question. Create an insert statement to add a new vendor in the AP database. The new vendor information is as follows:

$--$VendorID $=124$

$--$VendorName $=$ My Express Corp

$--$VendorAddress$1=$ P$.$O$.$ Box $2424$

$--$VendorAddress$2=$ Dept A

$--$VendorCity $=$ Wichita

$--$VendorState $=$ KS

$--$VendorZipCode $=67204$

$--$VendorPhone $=(800)555-1234$

$--$VendorContactLName $=$ Williams

$--$VendorContactFName $=$ Joe

$--$DefaultTermsID $=3$

$--$DefaultAccountNo $=553$

Q$4.$ Use the AP database for this question. Write a SQL query that returns one column from the Vendors table named Full Name. Create this column from the VendorContactFName and VendorContactLName columns. Separate the last name and first name by a comma $($for example $$Doe$,$ John$).$ Sort the result by last name, then by first name.

Q$5.$ Use the AP database for this question. Modify the SQL statement in the previous exercise to filter for contacts whose last name begins with the letter A$,$ B$,$ C$,$ or E$.$