SQL Online Exercise

Exercise

Please try a few exercises. Section 11 contains the interactive form, and links to the two tables:

customers(customerid, firstname, lastname, city, state)

items_ordered(customerid, order_date, item, quantity, price)

Note that this SQL interpreter does not support sub-SELECT statements or all SQL operators.

Write queries for the following (note that you can run the SQL query real-time in the dialog box at the bottom of each page):

Retrieve the total amount purchased by each customer, ordered by the customer with the highest total first.

Retrieve customers (firstname, lastname) from Arizona or Oregon that made purchases over \$20.

If a customer made single orders of $20-$50, we will apply a discount of 10%. However, if a customer made a single order >$50, we will apply a flat discount of $10. Retrieve the customers who qualify for such discounts and display their order price and order price after discounts were applied. (this can be done as 2 separate queries. How would you do it in one?)