MySql Intro - Please solve the following questions efficiently - Will thumbs up if all done correct. All tables from database provided in pictures. Let me know if there are any questions.

1. List the title_name and book type of the books that are published earlier than all biography books 2. List the title_name and book type of the books published by 'Abatis Publishers' 3. Find the name(s) of the publisher(s) that have not published any book 4. Find the name(s) of the publisher(s) who have published computer books