Paper 3: Challenge: joins, subqueries and writes
Chapter practice with ten items, answers and a one-line note for each, about 25 minutes.
| Item | Detail |
|---|---|
| Questions | 10 |
| Suggested time | 25 |
| Difficulty mix | Foundation 4 · Intermediate 2 · Challenge 2 · Error redo 2 |
| Chapter | Chapter: S3 ICT: databases and SQL queries |
| Level | Challenge |
| # | Answer | One-line note |
|---|---|---|
| 1 | 5 rows. | INNER JOIN keeps only rows matched in both tables, and five pupils joined a club. |
| 2 | 8 rows. | LEFT JOIN keeps all eight rows of the left table and leaves unmatched columns empty. |
| 3 | 4 rows. | The subquery finds the average of 72.5 first, then four pupils sit above it. |
| 4 | 2 rows. | Only the two form 2 pupils satisfy the WHERE condition. |
| 5 | 155. | The original 90 and 55 each gain five, so the total becomes 155. |
| 6 | 3 rows. | After the update three rows score 60 or less, and all of them are removed. |
| 7 | 5 rows. | The original eight rows minus the three deleted rows leave five. |
| 8 | 6 rows. | INSERT adds a single row, so five rows plus one make six. |
| 9 | 3. | DISTINCT removes duplicates before counting the different forms. |
| 10 | HAVING, because it runs after the grouping is complete. | WHERE filters rows before grouping, and writing it in the HAVING position raises an error. |
Want the whole chapter? See all four difficulty papers on the chapter page.Tutor Registration →
Questions and answers are written originally by the TutorZone team and are not taken from any school, publisher or examination authority paper. Every value is checked by computer.

