Make a list of at least two different queries you could create related to this e

Question

Make a list of at least two different queries you could create related to this event database. Remember that you can run queries on a single table, or, because these tables are joined in relationship, you can run queries based on multiple tables. One of the two queries should be a multiple-table query.
Your query list should include-type of query ( I.e simple query, exact match, parameter, cross tab, etc), the fields you would include in the query, any conditions placed on the criteria line( I.e Finish race, "YES",) and purpose of the query. Make a list of at least two different queries you could create related to this event database. Remember that you can run queries on a single table, or, because these tables are joined in relationship, you can run queries based on multiple tables. One of the two queries should be a multiple-table query.
Your query list should include-type of query ( I.e simple query, exact match, parameter, cross tab, etc), the fields you would include in the query, any conditions placed on the criteria line( I.e Finish race, "YES",) and purpose of the query. Make a list of at least two different queries you could create related to this event database. Remember that you can run queries on a single table, or, because these tables are joined in relationship, you can run queries based on multiple tables. One of the two queries should be a multiple-table query.
Your query list should include-type of query ( I.e simple query, exact match, parameter, cross tab, etc), the fields you would include in the query, any conditions placed on the criteria line( I.e Finish race, "YES",) and purpose of the query.

Explanation / Answer

1. select e.title from paper e where 20 < (select count(*) from PaperByAuthors ea where (ea.paperId = e.paperId)) order by e.title;

2. select name from author where authorid IN ( Select b.authorID from PaperbyAuthors b   group by authorId   order by count(*), author.name DESC limit 20 );

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.