Paper 2: Advanced: filters, LIKE and sorting
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 | Advanced |
| # | Answer | One-line note |
|---|---|---|
| 1 | 5 rows. | Five pupils score 70 or above, so the other three are filtered out. |
| 2 | 6 pupils. | IN works like a list of OR tests: three in form 1 plus three in form 3. |
| 3 | 4 rows. | BETWEEN includes both ends, and four pupils fall inside that band. |
| 4 | 3 pupils. | The names ending in n are Ben, Dan and Finn. |
| 5 | 5 pupils. | Any name holding an a in any position counts, which gives five. |
| 6 | Gina with 95. | DESC sorts from high to low and LIMIT 1 keeps only the first row. |
| 7 | Hugo with 50. | ASC sorts from low to high, so the lowest score comes first. |
| 8 | 3 groups. | The table holds forms 1, 2 and 3, which produce three groups. |
| 9 | 2 groups. | Forms 1 and 3 hold three pupils each, and form 2 with two pupils is dropped. |
| 10 | No, comparisons against NULL need `IS NULL`. | NULL means an unknown value, so every equals or not-equals test against it is false. |
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.

