Write a query to display the author last name, author first name, book title, and book cost for each book written by that author. Sort the results by author first name (hint: you need to join tables). New to SQL Please HELP.

Here are .csv I imported into MySQL Workbench

Here are what is inside those .csv files

AuthorBooksWrites

Here is how the final output is suppose to look:

fact Tables author Columns AU_ID AU_FNAME AU_LNAME AU_BIRTHYEAR Indexes Foreign Keys Triggers book Columns BOOK_NUM BOOK_TITLE BOOK_YEAR BOOK_COST BOOK_SUBJECT PAT_ID Indexes Foreign Keys Triggers checkout Columns CHECK_NUM BOOK_NUM PAT_ID CHECK_OUT_DATE CHECK_DUE_DATE CHECK_IN_DATE Indexes Foreign Keys Triggers patron Columns PAT_ID PAT_FNAME PAT_LNAME PAT_TYPE Indexes Foreign Keys Triggers writes Columns BOOK_NUM AU_ID Indexes Foreign Keys Triggers AU_BIRTHYEAR 1990 1983 1972 1969 1961 AU_ID AU_FNAME AU_LNAME 185 Benson Reeves 218 Rachel Beatney 229 Carmine Salvadore 251 Hugo Bruer 262 Xia Chiang 273 Reba Durante 284 Trina Tankersly 383 Neal Walsh 394 Robert Lake 438 Perry Pearson 460 Connie Paulsen 559 Rachel McGill 581 Manish Aggerwal 592 Lawrence Sheel 603 Julia Palca 1980 1982 1986 1983 1984 1976 1988 BOOK_NUM BOOK_TITLE 5235 Beginner's Guide to JAVA 5236 Database in the Cloud 5237 Mastering the database environment 5238 Conceptual Programming 5239 J++ in Mobile Apps 5240 iOS Programming 5241 JAVA First Steps 5242 C# in Middleware Deployment 5243 DATABASES in Theory 5244 Cloud-based Mobile Applications 5245 The Golden Road to Platform independence 5246 Capture the Cloud 5247 Shining Through the Cloud: Sun Programming 5248 What You Always wanted to Know About Database, But Were Afraid to Ask 5249 Starlight Applications 5250 Reengineering the Middle Tier 5251 Thoughts on Revitalizing Ruby 5252 Beyond the Database Veil 5253 Virtual Programming for Virtual Environments 5254 Coding Style for Maintenance BOOK_YEAR BOOK_COST BOOK_SUBJECT PAT_ID 2014 59.95 Programming 2014 79.95 Cloud 2015 89.95 Database 2015 59.95 Programming 1229 2015 49.95 Programming 2015 79.95 Programming 1212 2015 49.95 Programming 2015 59.95 Middleware 1228 2015 129.95 Database 2015 69.95 Cloud 2016 119.95 Middleware 2016 69.95 Cloud 1172 2016 109.95 Programming 2016 49.95 Database 2016 69.95 Cloud 1207 2016 89.95 Middleware 2016 59.95 Programming 2016 69.95 Database 1229 2016 79.95 Programming 2017 49.95 Programming BOOK_NUM AU_ID 5235 273 383 5236 5237 185 603 5238 5239 229 460 5239 5239 592 5240 218 460 559 5241 5241 5242 5243 581 251 262 5244 5244 284 394 5245 5246 251 5247 394 5248 229 5249 262 5250 383 5250 438 460 262 5251 5252 5253 5254 185 559 AU_FNAME AU_LNAME BOOK_TITLE BOOK COST Benson Reeves Mastering the database environment 89.95 Benson Reeves Virtual Programming for Virtual Environments 79.95 Carmine Salvadore J++ in Mobile Apps 49.95 Carmine Salvadore What You Always wanted to Know About Datab... 49.95 Connie Paulsen J++ in Mobile Apps 49.95 Connie Paulsen JAVA First Steps 49.95 Connie Paulsen Thoughts on Revitalizing Ruby 59.95 Hugo Bruer DATABASES in Theory 129.95 Hugo Bruer Capture the Cloud 69.95 Julia Palca Conceptual Programming 59.95 Lawrence Sheel J++ in Mobile Apps 49.95 Manish Aggerwal C# in Middleware Deployment 59.95 Neal Walsh Database in the Cloud 79.95 Neal Walsh Reengineering the Middle Tier 89.95 Perry Pearson Reengineering the Middle Tier 89.95 n