Please use SQL to solve those problems

Consider the computer science bibliography domain described in Lab Assignment 1. Consider the schema in Figure 1 to model this domain Each author in table Authors is identified by a unique authorID which is autogenerated. Each author has a first name, a last name and an email. The email is unique, while the first name and last name may not be unique. Each paper is identified by a unique paperID which is autogenerated. For each paper, we keep in table Papers the title, a short abstract, the year it was published, and the venue where i was published The title, year and venue are unique for every paper. The table PapersBy Authors maintains the relationships between papers and authors of a paper, identifying authors by authorID, and papers by paperID. The pair authorld,paperID is unique. Each paper is published at a venue. The table Venues holds data about venues. Each venue is identified by a unique venuelD which is autogenerated. The venue can be of type conference, or of type journal. Therefore, attribute type takes two possible values: conference orjournal. For each venue, we keep the name and the abbreviation. Finally, every paper cites other papers. The citations are saved in table Citations, where each tuple (paperID,citationID) means that a paper identified with paperD cites another paper identified with citationID firstName (varchar(32)paperlD (int) lastName (varchar(32)) email (varchar(32)) paperlD (int) citationlD (int) paperID (int title (varchar(100)) year (int) venuelD (int) name (varchar(100)) acronym (varchar(16)) type (char(10) Figure 1. Schema for the computer science bibliography database