Homework answers / question archive / Utilizing Furniture Company database posted in Canvas, define and execute SQL statements to retrieve data for each of the following queries

Utilizing Furniture Company database posted in Canvas, define and execute SQL statements to retrieve data for each of the following queries

Unrecognized

Share With

Utilizing Furniture Company database posted in Canvas, define and execute SQL statements to retrieve data for each of the following queries. Use SQLite to run your queries and include a screenshot of the result for each question. ------------------------------------------------------------------------------------------------------------- 1. Retrieve customer ID and name that purchased any product with less than the average standard price of all products. 2. Display the ProductFinish of the products that are placed in 3 or more orders. 3. Retrieve name and IDs of customers that have not placed any orders or they are located in Texas. Sort the result based on the customer ID. 4. What are the customer states and their order IDs that include product(s) with more than the average standard price? (use EXISTS operator) 5. List customer names and states that ordered products with “Natural Ash” finish and are located outside California. (use EXISTS operator)