2. According to the diagram structure you created, write the queries; 1 where+like query, 1 nested (sub query) select, 1 query containing group by+avg, 1 top+order by, 1 query that includes group by+ sum+count, 1 group by+having, 1 join+group by+avg, 1 join+group by+avg+where , 1 max-min, 1 IN. In addition, you are requested to show the results of these queries as a screen output

Show the result as scren shot

It is not important insert what ever you wish I just need codes and screen shots of results. Values are not important even you can insert donkey for every value

4 Authors 6 7 lid 8 1 2 3 4 9 10 11 12 Authors Name Furkan Saglam Salih Kaya Ouzhan Kaya Berke imal Authors bio furkan was born in 1997 he studied bilgi university salih was born in 1996 he studied bilgi university ouzhan was born in 1995 he stuied bilgi university berke was born in 1998 he studied bilgi university 9 - Menino MOONID rechou 1 ay 2ary 34 -- Sess: 90 Member MIT TOGAR Members Member oma mere tema Turma.com Dermall.com Member phone 355455555 51-16567131 515 S1858505 be Author books ciste AU AUTHOR ter |||||||||||||||||| met Advents. And M 19 IWW 13 14 1 15 ld 16 17 18 Library_books library book condition To be received after 10 days To be received after 8 days To be received after 3 days To be received after 9 days Library Book isbn ISBN 478569712354 ISBN 457896312547 ISBN 321478985314 ISBN 547896547423 2 3 4 20 4 5 Authors 1 6 7 id 8 9 10 11 12 2 3 Authors Name Furkan Saglam Salih Kaya Ouzhan Kaya Berke imal Authors bio furkan was bom in 1997 he studied bilgi university salih was born in 1996 he studied bilgi university oguzhan was born in 1995 he stuied bilgi university berke was born in 1998 he studied bilgi university 4 6. Library database authors author_books Id VARCHAR(36) isbn VARCHAR(36) name VARCHAR(60) +---- title VARCHAR(200) bio VARCHAR(1000) author_id VARCHAR(36) genre VARCHAR(36) 1-H description VARCHAR(1000) library books date_published DATE id VARCHAR(36) > - isbn VARCHAR(36) condition VARCHAR(36) members id VARCHAR(36) name VARCHAR(100) email VARCHAR(100) phone_number VARCHAR(36) HI- member_books member_id VARCHAR(36) book_id VARCHAR(36) date_checked_out DATE