Into to MySQL - Aggregation. Will thumbs up if all 3 questions are answered correctly. I have a database with the following tables Authors, Publishers, Royalties, Title_authors, Titles Picture of Titles table provided. Solve the following three questions using it.

mysql> describe titles; | Field | title_idchar (3) Type | Null | Key | Default | Extra | PRI I NULLI | title_name | varchar(4)No NULL varchar (10) YES YES YES NULL NULL NULL Ul char pages I decimal(5,2) | YES | | NULL | NULL NULL sales pubdate I contract smallint (6) NO 9 rows in set (0.00 sec) mysql> select title_id, title_name, type, pub_id, pages, price, sales, pubdate, contract from titles; |title id I title name NULL type | pub_id | pages | price |sales pubdatecontractI |1977! | history Pe1 107 | 21.99| 566 | 2000-08-01| history Pe314 19.95 9566 1998-04-01 | | computer P21226 39.95 25667 | 200e-09-01| | psychology | P04510 | 12.9913001 1999-05-31 I | psychology P042016.95201440| 2001-01-01 | | biography P01473 19.9511320 | 2000-07-31 | | biography P03333 | 23.95 | 1500200 | 1999-10-01| | childrenP0486 1004095 | 2001-06-01 | | childre P0422| 13.95 2002-05-31 I T02 200 Years of German Humor Ask Your System Administrator | But I Did It Unconsciously Exchange of Platitudes How About Never? T06 T07 | I Blame My Mother | Just Wait Until After School Kiss My Boo-Boo |Not Without My Faberge Egg T09 | biography Pe1 NULL NULL NULL NULL | Perhaps It's a Glandular Problem psychologyIPe4826 7.9994123 | 2000-11-30 I | biography Pe1 07 12.99 1000e1 | 2000-08-31 I What Are The Civilian Applications? | history P03 802 | 29.9910467| 1999-05-31 I | Spontaneous, Not Annoying 1 T13