fundamentals/database/notes/09-subqueries-views-worksheet.md

Sub-queries and views worksheet

Sub-queries

1. Get all the students whose IQ is greater than the average IQ.

2. Get all the students whose IQ is greater than the highest IQ of the batch_id 2 students.

3. Get all the students whose IQ is greater than all the IQs of the batch_id 2 students.

4. Find all the students who are in batches that start with the word Jedi (Without JOIN)

5. Find all the students whose IQ is greater than the average IQ of their batch.

6. Get all the instructors that have at least one batch (Without using joins)

7. Print all the names, batch ID and average IQ of the batch for each student

Views

1. Create a view that shows the students and their batches.

2. Create a view that shows the students and their batches, but only for batches that start with the word Jedi.