We have an online grocery store. Customers can order grocery items and they receive a bill for their order that looks like this:
The data is contained in a SQLITE database.
You can access the database here.
-
Write a sql statement to show
-
all service order headers
-
all service order numbers with the customer name
-
service order 1234 details
- service order number
- customer name
- product name
- qty
- price
- total for the line
-
the total invoice price for each service order
-
the max price paid for an Apple
-
-
Look at the details for so_number = 1237. Notice there is only one line item, but it has been updated.
Write a statement to show
-
the most recent version of this line item
