1. Write a query that shows the total number of orders that have shipped in 2008. Label the data "Orders Shipped in 2008".
2. Write a query that shows the earliest publication date of books in the children category.
3. Write a query that displays each shipstate along with the number of orders shipped to that state. Display the results in descending order by state.
4. Write a query that displays order number and the total paid for each order. Format the amount using dollars and cents. Label the total amount "Order Total."
5. Write a query to show the retail price of the least expensive book written by Lisa White.

ables n steps ORDERS im denei higstate BOOKAUTHOR AUTHOR uantty DcountPUBLISHER the ng tables r each bere must hrough a primary urpose of n kuy FIGURE 1-5 Justlee Books's table structures ater nomalization Figare 1-6 shows a portion of the BOOKS table and the fields it contains after ornalzation. As mentioned, each field represents a characteristie, or attrilute, that's wing collested for an entity. The group of attributes for a specific occurrence (for iutiple, a customer or a booki is called a record. In Oracle 12e, a list of a table's contents ns columns to represent fields and rotes to represent records. These terms are used sterchangeably throughout this textbook, e, instead lisher an a forening oon a foreign ode could tionships the data RS table B0DVBURLD IN 10 MINUTES A DAY 21-JAN-os enon atisonship nd serves 41140933 REVENCE OF MICKEY e1410 BULDING A CAR WITH TOOTHICKS 18-MAR 0 FAMLY LIFE CHILDREN 01THE WOK WAY TO COOK or1243 HOW TO CAT FASTER PIZZA 2147420 SHORTEST FOEMS r bridging 1-SEP-00 the tice As en table keys TO MANAGE THE MANAGER 09 MAY-9 o1-MAY 21 the ary le 1-4 A portion of the B00KS table aher normalzation Overview of Database Concept