Consider the conference database system, which is used to keep track of author, reviewers, and paper submissions. Reviews by reviewers are recorded for use in the paper selection Consider the conference database system, which is used to keep track of author, reviewers, and paper submissions. Reviews by reviewers are recorded for use in the paper selection process. The database system caters primarily to reviewers who record answers to evaluation questions for each paper they review and make recommendations whether to accept or reject the paper. The data requirements are summarized as follows:

$$ Authors of papers are uniquely identified by their email id$.$ Their first and last names are also recorded.

$$ Each paper is assigned a unique identifier by the system and is described by a title, an abstract$,$ and a file name.

$$ A paper may may have multiple authors, but one of the authors is designated as the contact author.

$$ Reviewers of papers are uniquely identified by their email address. Each reviewer's first name, last name, phone number, affiliation, and topics of interest are also recorded.

$$ Each paper is assigned between two and four reviewers. A reviewer rates each paper assigned to him or her on a scale of $1$ to $10$ in four categories : technical merit, readability, originality, and relevance to the conference. Finally, each reviewer provides an overall recommendation regarding each paper.

$$ Each review contains two types of written comments: one to be seen by the review committee only and the other as feedback to the the author$($s$).$

The conference relational schema diagram is given to you.

$$

You are required to use the conference.sql given in the Assignment folder to create and populate the tables for the conference review database system. You are not allowed to change the structure of the tables; however, you can add rows to test your queries.

$$

$$

Answer the following as SQL queries for the oracle $10$g$/11$i$/12$c database system. You are not allowed to create any additional tables or views to answer the queries.

$$

$1.$ List the names of participators who have written more than $3$ papers.

$2.$ List the names of contact authors.

$3.$ List the names of reviewers who have not reviewed any papers.

$4.$ List the name of reviewers along with the number of papers they have reviewed.

$5.$ Print the names of reviewers who reviewed ALL the papers in the system.

$6.$ Print the paper id$,$ title and the average overall recommendation value of all papers sorted in decreasing order of overall recommendation value. Do not show papers below an average overall rating of $3\mathrm{.}0.$

$7.$ Print the names of participators who have written the highest number of papers.

$8.$ Print the names of authors who have reviewed their own papers.

$9.$ List the titles of papers co$-$authored by more than $5$ people?

$10.$ Print the names of tough reviewers. Tough reviewers are ones who have given the lowest overall recommendation $($overallrecomm$)$ value that a paper has for each$$of the papers they have reviewed.

$11.$ Print the names of participators whose phone number starts with area code $414.$

$12.$ Print the names of participators who have written and reviewed a paper in the system.

$13.$ List the paper id and title of papers whose comments for author has a keyword $$good$$ mentioned.

$14.$ List the emails, names of participators along with the number of papers written by each participator. The count value should show $0$ in the result for participators who have not written a paper.

$15.$ Print the pairs of names of reviewers along with their topic of interest who share the same topics of interests.