1. Display the order# and the shipment status (name this column as "Status") of each order. The

In this question, there is an assignment that refers to a table in the Just Leave Books database

Question

1. Display the order# and the shipment status (name this column as "Status") of each order. The shipment status of those orders that have not been shipped should be "Not Shipped", and the status of those shipped orders should be "Shipped". (Please print your SQL statement here): 2. How many months are there between today and 12/14/2001? Please round the number of months to the nearest integer (whole number). (Please print your SQL statement here): How many months does your query return? months. 3. Use one SQL statement with subqueries to display the category name and the average book retail price of the book category that has the lowest average book retail price. (Please print your SQL statement here): What's the category name? 4. Use one SQL statement with subqueries to display the title and the publisher's name of the book that generates the highest total profits from all orders stored in the database. The book's title is , and its publisher's name is . 5. Write an anonymous PL/SQL block using a WHILE LOOP statement to display the value of Y to your screen, where Y=11+22+33+44+...+ 9898+9999+100*100. (Please print your PL/SQL block here):

          1. Display the order# and the shipment status (name this column as "Status") of each order. The shipment status of those orders that have not been shipped should be "Not Shipped", and the status of those shipped orders should be "Shipped".
(Please print your SQL statement here):
2. How many months are there between today and 12/14/2001? Please round the number of months to the nearest integer (whole number).
(Please print your SQL statement here):
How many months does your query return? ______ months.
3. Use one SQL statement with subqueries to display the category name and the average book retail price of the book category that has the lowest average book retail price.
(Please print your SQL statement here):
What's the category name? ______
4. Use one SQL statement with subqueries to display the title and the publisher's name of the book that generates the highest total profits from all orders stored in the database.
The book's title is ______, and its publisher's name is ______.
5. Write an anonymous PL/SQL block using a WHILE LOOP statement to display the value of Y to your screen, where Y=1*1+2*2+3*3+4*4+...+ 98*98+99*99+100*100.
(Please print your PL/SQL block here):

1. Display the order# and the shipment status (name this column as "Status") of each order. The shipment status of those orders that have not been shipped should be "Not Shipped", and the status of those shipped orders should be "Shipped".
(Please print your SQL statement here):
2. How many months are there between today and 12/14/2001? Please round the number of months to the nearest integer (whole number).
(Please print your SQL statement here):
How many months does your query return? months.
3. Use one SQL statement with subqueries to display the category name and the average book retail price of the book category that has the lowest average book retail price.
(Please print your SQL statement here):
What's the category name?
4. Use one SQL statement with subqueries to display the title and the publisher's name of the book that generates the highest total profits from all orders stored in the database.
The book's title is , and its publisher's name is .
5. Write an anonymous PL/SQL block using a WHILE LOOP statement to display the value of Y to your screen, where Y=1*1+2*2+3*3+4*4+...+ 98*98+99*99+100*100.
(Please print your PL/SQL block here):

Added by Rosario K.

Question

Please give Ace some feedback