Class, lets use the PUBS Database to create some views. You can find the script and ERD for the PUBS database in the Announcement area under Week 7. Before posting any of these exercises, be sure to first execute the script and try out your View in MySQL.

5. Create a view named Authors_Titles_V that contains the author ID, author name, the title id, the title of the book, and the YTD sales. Display the author name and the title of the book only using this view. Show your results.

publishers employee pub jid emp.id job id ob_desc name country I au id hire date titles title id titleauthor e title id au ord stores sales title id