Question
Write the SQL statements to satisfy the requests below. Use either the 'Traditional' or 'JOIN' method: 1) Create a list that displays the title of
Write the SQL statements to satisfy the requests below. Use either the 'Traditional' or 'JOIN' method:
1) Create a list that displays the title of each book and the name and phone number of the contact at the publishers office for reordering each book.
2) Produce a list of all customers who live in the state of Florida and have ordered books about computers. List each customer only once.
3) An EMPLOYEES table was added to the JustLee Books database to track employee information. Display a list of each employees name, job title, and managers name. Use column aliases to clearly identify employee and manager name values. Include all employees in the list and sort by manager name.
4) The Marketing Department of JustLee Books is preparing for its annual sales promotion. Each customer who places an order during the promotion will receive a free gift with each book purchased. Each gift will be based on the books retail price. JustLee Books also participates in co-op advertising programs with certain publishers. If the publishers name is included in advertisements, JustLee Books is reimbursed a certain percentage of the advertisement costs. To determine the projected costs of this years sales promotion, the Marketing Department needs the publishers name, profit amount, and free gift description for each book in the JustLee Books inventory. (Hint: use a non-equality join to look up them gift from the promotion table using the retail column in the books table.)
5) Also, the Marketing Department is analyzing books that dont sell. A list of ISBNs for all books with no sales recorded is needed. (Hint: Build a query to list ISBNs of all book. Then build a second query to list ISBNs of books sold. Use the MINUS set operator to subtract the results of the second query from the results of the first query.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started