Write and execute (test) SQL queries to answer the following using the Pine Valley Furniture (PVFC) database in Oracle SQL Developer. An ERD is available from the lms lab area. 1. List the product ID, product description, and product standard price where the product finish is Oak and the product standard price is greater than $500.

2. List the name and address of all customers whose name contains the string Furniture and sort them alphabetically.

3. List the number of employees who live in Knoxville

4. For each state, list the number of customers living there. The list should be sorted alphabetically by state.

5. List the product finishes which are used on more than 2 products.

6. List the order date, customer name, customer address, and customer city of all orders from New York State.

Pvrc-2019wl_INro_1 103, C Get llomework Help with C @) PVrc(1).pdf O file/C/Users/ZKSym/AppData/Local/Packages/Microsoft. Microsoftedge 8wekyb3d8bbwe/lemp K%20( 1].pdf .. Pvrc-2019wl_INro_1 103, C Get llomework Help with C @) PVrc(1).pdf O file/C/Users/ZKSym/AppData/Local/Packages/Microsoft. Microsoftedge 8wekyb3d8bbwe/lemp K%20( 1].pdf