Using the correct tables, create a sub query using either join operation you wish that will list the customer number, first and last name concatenated together, city and number of copies ordered for all customers who have placed an order for the most expensive book (based on retail price). Give the combined customer names column and alias of “Customer Name”.
STEP 2:
Back to top
Using the ORDER_ITEMS table, create a query using the correct functions to return the item number, the total qu…
