Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 0 . Ellen asks you to give her a list of the books that each author wrote. Write a complete SQL statement to provide

10. Ellen asks you to give her a list of the books that each author wrote. Write a complete SQL
statement to provide the information to Ellen, including author names, book titles, publishers, and the years of publication. LO 4-2, LO 4-3
11. Ellen wants to know how many books each author wrote. Write a SQL statement to provide such information to Ellen. LO 4-2, LO 4-3
12. You are going to send emails to inform the customers that the books ordered have been
shipped. Write a SQL statement to obtain the complete information on the book title(s),
unit price(s), and the number of each book purchased to be sent to the customers. LO 4-2,
LO 4-3
13. Ellen wants to know how many copies of each book were sold. Write a SQL statement to
obtain the necessary information you think Ellen wants. LO 4-2, LO 4-3
14. Ellen wants to know the dollar amount of total sales made on September 1,2017. Write a
SQL statement to obtain the necessary information you think Ellen wants. LO 4-2, LO 4-3

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DNA Databases

Authors: Stefan Kiesbye

1st Edition

0737758910, 978-0737758917

More Books

Students also viewed these Databases questions

Question

Is this Boolean expression a sum of product or product of sum?

Answered: 1 week ago

Question

List the different categories of international employees. page 642

Answered: 1 week ago

Question

Explain the legal environments impact on labor relations. page 590

Answered: 1 week ago