1. Determine how many books are in the Cooking category 2. Display the number of

Question

1. Determine how many books are in the Cooking category
2. Display the number of books that have a retial value of more than $30.00.
3. Display the date of the most recently published book.
4. Determine the total profit generated by sales to customer 1017.
5. List the most expensive book purchased by customer 1017.
6. List the least expensive book in the computer category.
7. Determine the average profit generated by orders containted in the ORDERS table.
8. Determine how many orders have been placed by each customer in the CUSTOMERS table. Do not include any customer in the results who has not recently placed an order with Just Lee Books.
9. List the customers living in Georgia or Florida who have recently placed an order totaling more than $80.
10. What is the retail price of the most expensive book written by Lisa White.

Explanation / Answer

Need more info than that. Table and column names would be great. 1. SELECT COUNT (column_name_goes_here) FROM table_name_goes_here WHERE category = 'Cooking' 2. SELECT COUNT (column_name) FROM table_name WHERE value > 30 3. SELECT MIN(date) as recentDate FROM table_name GROUP BY date 4. SELECT SUM(profit) FROM table_name WHERE customer_id = 1017 5. SELECT MAX(purchased) FROM table_name WHERE customer_id = 1017 6. SELECT MIN(purchased) FROM table_name WHERE category = 'computer' 7. SELECT AVG(profit) FROM orders 8. SELECT COUNT(orders) FROM customers WHERE company 'Just Lee Books' 9. SELECT customer_name FROM customers WHERE order_cost > 80 AND order_date > '1/1/2010' 10. SELECT MAX(cost) FROM book_list_table WHERE author = 'Lisa White'

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---