1. Write a query to display the author ID, first and last name for all authors that have never written a book with the subject Programming. Sort the results by author last name. (See the figure below for the output) 2. Write a query to display the book number, title, subject, author last name, and the number of books written by that author. Limit the results to books in the Cloud subject. Sort the results by book title and then author last name. (See the figure below for the output) 3. Write a query to display the lowest average cost of books within a subject and the highest average cost of books within a subject.
1. Write a query to display the author ID, first and last name for all authors that have never written a book with the subject Programming. Sort the results by author last name. (See the figure below for the output) 2. Write a query to display the book number, title, subject, author last name, and the number of books written by that author. Limit the results to books in the Cloud subject. Sort the results by book title and then author last name. (See the figure below for the output) 3. Write a query to display the lowest average cost of books within a subject and the highest average cost of books within a subject.
Chapter8: Mastering Digital Media
Section: Chapter Questions
Problem 2AYK
Related questions
Question
1. Write a query to display the author ID, first and last name for all authors that have never written a book with the subject
2. Write a query to display the book number, title, subject, author last name, and the number of books written by that author. Limit the results to books in the Cloud subject. Sort the results by book title and then author last name. (See the figure below for the output)
3. Write a query to display the lowest average cost of books within a subject and the highest average cost of books within a subject. (See the figure below for the output)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Microsoft Windows 10 Comprehensive 2019
Computer Science
ISBN:
9780357392607
Author:
FREUND
Publisher:
Cengage
Microsoft Windows 10 Comprehensive 2019
Computer Science
ISBN:
9780357392607
Author:
FREUND
Publisher:
Cengage