/en-tutor-prep-s3-ict-databases-sql-queries-practice-3/
/en-tutor-prep-s3-ict-databases-sql-queries-practice-3/
General Inquiry: info@TutorZone.com.hk
Office Hours: Monday to Saturday - 9:00 AM to 6:00 PM
WhatsApp Monday to Sunday - 24 hours
Hotline: +852 6828 1809
Instant Support: +852 9061 3106

Paper 3: Challenge: joins, subqueries and writes

Paper 3: Challenge: joins, subqueries and writes

  • 2026-11-21

Paper 3: Challenge: joins, subqueries and writes

Chapter practice with ten items, answers and a one-line note for each, about 25 minutes.

Paper 3 Ten items on this chapter with answers for immediate marking.

01 Paper details (check answers afterwards)

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

02 Questions (10 items)

  1. FoundationHow many rows does `students INNER JOIN clubs ON clubs.sid = students.id` return?
  2. FoundationWith the same condition, how many rows does LEFT JOIN return?
  3. FoundationHow many rows does `WHERE score > (SELECT AVG(score) FROM students)` return?
  4. FoundationHow many rows does `UPDATE students SET score = score + 5 WHERE form = 2;` change?
  5. IntermediateAfter that update, what is the total score of form 2?
  6. IntermediateHow many rows does `DELETE FROM students WHERE score <= 60;` remove?
  7. ChallengeHow many rows remain in the table after that delete?
  8. ChallengeAfter one more row is inserted, how many rows does the table hold?
  9. Error redoWhat is the result of `SELECT COUNT(DISTINCT form) FROM students;`?
  10. Error redoTo filter groups after GROUP BY, should WHERE or HAVING be used?

03 Answers and one-line notes

# 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.

04 What to do after marking

  • After marking, redo only the wrong items and write down which step went wrong (formula, unit, or misread number).
  • Repeat the same item two days later; move to the next paper only when both attempts are correct.
  • Parents only need the answer and note columns; there is no need to explain every item.

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.

Join as a tutor or coach — academic, music, sports, arts, STEM. Free to register. See how it works →