Please can someone help with these questions: -
Given the tables of a database below, write an sql statement which merges the author names and the names of the titles they have published into a new table. The result has to be sorted using the title names. The asterisks (*) indicate the primary keys. The relationships are ISBN (Titles) to ISBN (Author_title) as 1:n without referential integrity. Author_ID (Author_title) to Author_ID (Author) as n:1 with referential integrity.
Titles Author_title Author
(*)ISDN ISBN (*)Author_ID
title_name Author_ID Author_name