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).
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).
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...
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

Transcribed Image Text: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

Transcribed Image Text: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

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

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
Recommended textbooks for you

Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON

Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science

Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning

Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON

Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science

Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning

Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning

Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education

Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY