Answered You can hire a professional tutor to get the answer.
Develop SQL queries to retrieve the required information from the following tables.
Develop SQL queries to retrieve the required information from the following tables. Items (item_id, designation, price) Items_ordered (customerid, order_date, item_id, quantity, billing_price) Customers (customerid, firstname, lastname, city, state) Note: Some customers get a discount, so the billing_price may differ from the standard price. a. List all items purchased by customerid 10449. Display the customerid, item, and the billing_price paid by this customer. b. Select the maximum price of any item ordered. c. List the designation and the average price for each item ordered between the 15th of November and the 20th of December. d. Show how many customers there are in each state. Display the results alphabetically by state. e. List all items with their standard price, maximum billed price, and minimum billed price. f. Show the number of orders placed by each customer. Display the results alphabetically by state. g. Select the lastname, firstname, and city of all customers who purchased an item for more that $1000. Display the results alphabetically by last name. h. Select the firstname, city, and state for the customers who ordered a “tent,” and who are living in either Arizona, Washington, Oklahoma, Colorado, or Hawaii. i. Using Join, list the items each customer ordered where the billing_price was lower than the item price (item, billing_price, and price). Sort the results alphabetically by customer name.
