Write a query to display the author ID, first name, last name, and year of birth for all authors. Sort the results in descending order by year of birth, and then in ascending order by last name AU_ID AU_FNAME AU_LNAME AU_BIRTHYEAR 185 Benson 603 Julia 438 Perry 581 Manish 218 Rachel 460 Connie 394 Robert 383 Neal 592 Lawrence 251 Hugo Reeves Palca Pearson Aggerwal Beatney Paulsen Lake Walsh Sheel Bruer 1990 1988 1986 1984 1983 1983 1982 1980 1976 1972

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
icon
Concept explainers
Question
ERD:-
PK
CHECKOUT
Check Num
FK1 Book_Num
FK2 Pat_ID
Check Out Date
Check_Due Date
Check_In_Date
PK
BOOK
Book Num
Book Title
Book_Year
Book_Cost
Book_Subject
FK1 Pat_ID
-H-
PATRON
PK Pat ID
Pat_FName
Pat_LName
Pat_Type
WRITES
PK,FK1 Book Num
PK,FK2 Au ID
AUTHOR
PK AU ID
Au_FName
Au_LName
Au_BirthYear
Transcribed Image Text:ERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID -H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num PK,FK2 Au ID AUTHOR PK AU ID Au_FName Au_LName Au_BirthYear
9. Write a query to display the author ID, first name, last name, and year of birth for all authors. Sort the
results in descending order by year of birth, and then in ascending order by last name
AU_ID AU_FNAME AU_LNAME AU_BIRTHYEAR
185 Benson
603 Julia
438 Perry
581 Manish
218 Rachel
460 Connie
394 Robert
383 Neal
592 Lawrence
251 Hugo
273 Reba
284 Trina
262 Xia
559 Rachel
229 Carmine
Reeves
Palca
Pearson
Aggerwal
Beatney
Paulsen
Lake
Walsh
Sheel
Bruer
Durante
Tankersly
Chiang
McGill
Salvadore
1990
1988
1986
1984
1983
1983
1982
1980
1976
1972
1969
1961
Transcribed Image Text:9. Write a query to display the author ID, first name, last name, and year of birth for all authors. Sort the results in descending order by year of birth, and then in ascending order by last name AU_ID AU_FNAME AU_LNAME AU_BIRTHYEAR 185 Benson 603 Julia 438 Perry 581 Manish 218 Rachel 460 Connie 394 Robert 383 Neal 592 Lawrence 251 Hugo 273 Reba 284 Trina 262 Xia 559 Rachel 229 Carmine Reeves Palca Pearson Aggerwal Beatney Paulsen Lake Walsh Sheel Bruer Durante Tankersly Chiang McGill Salvadore 1990 1988 1986 1984 1983 1983 1982 1980 1976 1972 1969 1961
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Query Syntax
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education