Create SQL Syntax: For each author, display author ID, first name, last name, and total number of books written by the author that have been sold. Display the output in descending order of total books sold

ORDERS CUSTOMERS Order Customer# Orderdate Customer# Lastname Firstname Emalil Address CI State Zip Referred Reglon Shipdate Shipcity Shipstate Shipzip Shipcost BOOKAUTHOR AUTHOR BOOKS ISBN AuthoriD AuthoriD Lname Fname ORDERITEMs ISN Order Item ISBN Quantity Paideach Pubdate PublD Cost Retail Discount Category PublD Name PROMOTION Contact Phone Minretail Maxretal