20 rows selected.
2.) Create a list of all customer numbers along with text indicating whether the customer has been referred by another customer. Display the text "NOT REFERRED" if the customer wasn't referred by another customer or "REFERRED" if they were. Hint: CASE statement.
3.) Create a list of all the book titles and costs. Precede each book's cost with asterisks so that the width of the displayed cost field is 12.
4.) Determine how many books are in the "Cooking" category.
5.) Display the number of books with a retail price of more than $30.00.
6.) Display the most recent publication date of all the books sold.
7.) List the retail price of the least expensive book in the "Computer" category.
