Question: Part III: SQL Create a set of sensible queries for the table according to the specifications described below. Use basic comparison operators (5 s, etc.,)


Part III: SQL Create a set of sensible queries for the table according to the specifications described below. Use basic comparison operators (5 s, etc.,) as well as at least one usage of either the keywords LIKE/NOT LIKE, BETWEEN/NOT BETWEEN or IN/NOT IN. [15]. For EACH SQL statement, provide a description of the query based on the information that it provides to a typical end-user. Sample Answer: SELECT performer, album, COUNT(Songtitle), sum(downloads) FROM albuminfo WHERE YEAR(releasedate) >= 2015 GROUP BY performer, album; Provide a list of the number of songs and total downloads for each album released since 2015. The performer should be included in the list. 1. Query with a WHERE condition using the AND and OR logical operators: 5 points Your answer 2. Query with a single-row function, a WHERE condition and sorting on more than one column:* 5 points Your answer 3. A top-N query: * 5 points Your answer 4. Query with one or more aggregate functions, the GROUP BY clause and the WHERE clause: * 5 points Your answer 5. Query with one or more aggregate functions, the GROUP BY clause and the HAVING clause 5 points Your
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
