Write a query to display the author ID, first and last name for all authors who have never written a book with the subject Programming. Sort the results by author last name (Figure P7.106). FIGURE P7.56 THE CH07_FACT ERDCНECКOUTPATRONPKCheck NumPK Pat IDFK1 Book_NumFK2 Pat_IDP0-----H-Check_Out_DateCheck_Due_DateCheck_In_DatePat_FNamePat_LNamePat_TypeBOOKAUTHORPKBook NumPK Au IDBook_TitleBook_YearBook_CostBook_SubjectFK1 Pat_IDAu_FNameAu_LNameAu_BirthYearWRITESPK,FK1 Book NumPK,FK2 Au ID Problem 106Write a query to display the author ID, first and last name for allauthors who have never written a book with the subjectProgramming. Sort the results by author last name (Figure P7.106).AU_IDAU FNAMEAU LNAME581ManishAggerwal251HugoBruer262XlaChiang438PerryPearson284TrinaTankersly383NealWalshFigure 7.106Taşk

Approach first we gonna to select all those book those are written in programing subject.(sub-query)…

Answered: Write a query to display the author ID,…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Write a query to display the author ID, first and last name for all authors who have never written a book with the subject Programming. Sort the results by author last name (Figure P7.106).

FIGURE P7.56 THE CH07_FACT ERD
CНECКOUT
PATRON
PK
Check Num
PK Pat ID
FK1 Book_Num
FK2 Pat_ID
P0-----H-
Check_Out_Date
Check_Due_Date
Check_In_Date
Pat_FName
Pat_LName
Pat_Type
BOOK
AUTHOR
PK
Book Num
PK Au ID
Book_Title
Book_Year
Book_Cost
Book_Subject
FK1 Pat_ID
Au_FName
Au_LName
Au_BirthYear
WRITES
PK,FK1 Book Num
PK,FK2 Au ID

Problem 106
Write a query to display the author ID, first and last name for all
authors who have never written a book with the subject
Programming. Sort the results by author last name (Figure P7.106).
AU_ID
AU FNAME
AU LNAME
581
Manish
Aggerwal
251
Hugo
Bruer
262
Xla
Chiang
438
Perry
Pearson
284
Trina
Tankersly
383
Neal
Walsh
Figure 7.106
Taşk

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

I tried using this and it gives me (Error Code: 1052. Column 'AU_ID' in field list is ambiguous) could you provide fix and explain why MySQL does this?

Solution