Question: Create one query with a JOIN and a GROUP BY clause (with aggregation functions) to return only the records of data that can be used


Create one query with a JOIN and a GROUP BY clause (with aggregation functions) to return only the records of data that can be used to answer all of the following questions (do not use a subquery) - Question: How many students have signed in each class? - Question: What are the earliest and latest signup_timestamp per class? - Question: Are any students signed up twice? - Hints and requirements: - Two tables are needed. - Please provide column aliases for aggregated columns - Include classes.code in the result set as a non-aggregated data item. - (table aliases are acceptable) - NOTE: duplicates is a "Boolean" not a count, o for no duplicates, 1 for duplicates Example: Deliverable 5: send your code \& screenshot Deliverable 6: Answer questions 111 - SELECT * FROM students 3 Edit: \[ \begin{array}{l} 85 \text { - SELECT * FROM registered_students; } \\ 86 \end{array} \]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
