How would in the display a list of all the data contained in the AUTHORS table?

Question

How would in the display a list of all the data contained in the AUTHORS table? How would you list the customer's last names, addresses and the state for all the customer who live in CA? How would you find a list of book titles where the profit is at $12? How would you create a list that shows the title of each book and the author's first and last name? How would you show the book category that generated more sales (purchases not profit) than any other? A display the number of sales for this category. How would you delete all the tables from the JustLee Database?

Explanation / Answer

6
Lets say there is "customers" table which contain all the details of the customers
SELECT lastname,address,state
FROM customers
WHERE state="CA"

8
Lets say there is "books" table in which title of the book and author name
SELECT title_of_book,firstName,lastName
FROM books

9
Lets say there is "category_sales" table which contain category and no of sales of that category
SELECT categery,sales
FROM category_sales
WHERE sales=(SELECT MAX(sales)
                                           FROM category)
                                          

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.