Page 1 - Home Assignment-Grouping Records and Joins in SQL
P. 1
Computer Science
Class – XII
Topic: Grouping Records and Joins in SQL
1. The _________________ clause can be used in a SELECT statement to collect data across
multiple records and group the results by one or more columns.
2. To specify filtering condition for a group the ________________ clause is used in MySQL.
3. In a select statement containing GROUP BY clause only ________________ and
____________________ can be used.
4. HAVING places condition only on ________________ and ____________________.
5. Differentiate where and having clause.
6. Write the syntax of select statement with all its clause.
7. Explain the concept of Cartesian Product between two tables, with the help of appropriate
example.
8. What is Equijoin? Explain by taking one example.
9. What is Natural join? Explain by taking one example.
10. Compare equijoin and natural join.
11. Observe the following PARTICIPANTS and EVENTS tables carefully and write the names of
the RDBMS operation which will be used to produce the output as shown in RESULT? Also,
find the Degree and Cardinality of the result.
12. Write SQL queries for (i) to (viii) based on the tables:
