Hi i need a help with this question please For the question: make sure to report the SQL code for each and every exercise, thank you!

You are given the following table, representing authorship of books: CREATE TABLE A BID VARCHAR(40) NOT NULL, AID VARCHAR (40) NOT NULL, CONSTRAINT PK PRIMARY KEY (BID, AID) Attribute BID identifies a book, attribute AID identifies an author. A record (BID, AID) represents the fact that individual is one of the authors of book , The following is a plausible instance of table A: 1 bid aid Confessions of a DBA | Ada 1 Confessions of a DBA | Bob Confessions of a DBA Carl i Falling in love with Relational Algebra Ada 1 | Falling in love with Relational Algebra 1 | Falling in love with Relational Algebra | Carl | Falling in love with Relational Algebra | Dave | NULL values and me Carl | Bob A Write a SQL select statement to identify the books with the largest number of authors. The expected result for the given database instance is: bid | Falling in love with Relational Algebra - 1 Make sure to adopt the same output-schema. Test your query in sqlfiddle.com, using PostGRES 9.6 and some arbitrary instance of table A. The relation produced by your query should always be a set B Two distinct individuals are co-authors if they share at least one book. Write a SQL select statement to identify the coauthors of 'Bob'. The expected result for the given database instance is: ---- aidi ------ | Carl | Dave | Ada ---- Make sure to adopt the same output-schema. Test your query in sqlfiddle.com, using PostGRES 9.6 and some arbitrary instance of table A. The relation produced by your query should always be a set. Notice that 'Bob' is not co-author to himself