These ten questions mix the skills from database queries and reports: multiple criteria, secondary sort keys, calculated fields, grouping and checking. All questions use one invented table of ten records, so you can work every answer out by hand. The names and numbers are made up.
Work each answer on paper first, then open the explanation. The questions run from easier to harder.
| ID | Name | Year | Club | Fee (RM) | Sessions (of 12) |
|---|---|---|---|---|---|
| 1 | Aiman | 10 | Chess | 30 | 8 |
| 2 | Bella | 11 | Drama | 45 | 12 |
| 3 | Chen | 10 | Drama | 45 | 9 |
| 4 | Dewi | 9 | Chess | 30 | 11 |
| 5 | Evan | 11 | Robotics | 60 | 7 |
| 6 | Farah | 10 | Robotics | 60 | 12 |
| 7 | Gopal | 9 | Drama | 45 | 6 |
| 8 | Hui | 11 | Chess | 30 | 10 |
| 9 | Imran | 10 | Chess | 30 | 12 |
| 10 | Jia | 9 | Robotics | 60 | 5 |
Questions
1. Which records match Club = “Drama” AND Fee > 40?
Show answer
All three Drama members pay RM45, which is above 40. Bella, Chen, Gopal, three records.
2. Which records match Year = 9 OR Sessions = 12? How many?
Show answer
Year 9: Dewi, Gopal, Jia. Sessions 12: Bella, Farah, Imran. No member is in both lists. Six records.
3. Which records match (Club = “Chess” OR Club = “Robotics”) AND Year = 10?
Show answer
Chess in Year 10: Aiman, Imran. Robotics in Year 10: Farah. Aiman, Imran, Farah, three records.
4. Which records have Sessions < 9 AND Fee < 50?
Show answer
Sessions below 9: Aiman (8), Evan (7), Gopal (6), Jia (5). Of these, Fee below 50 keeps Aiman (30) and Gopal (45). Evan and Jia pay 60. Aiman and Gopal.
5. Sort by Year ascending, then Sessions descending, then Name A to Z. Give the full order.
Show answer
Year 9: Dewi (11), Gopal (6), Jia (5). Year 10: Farah (12) and Imran (12) tie, so Name decides: Farah, Imran. Then Chen (9), Aiman (8). Year 11: Bella (12), Hui (10), Evan (7). Dewi, Gopal, Jia, Farah, Imran, Chen, Aiman, Bella, Hui, Evan.
6. A calculated field is Fee / Sessions. What is the value for Aiman?
Show answer
30 / 8 = 3.75, so RM3.75 per session.
7. Attendance = Sessions / 12 * 100. Give the value for Hui to one decimal place, and say what goes wrong if the field is also formatted as Percent.
Show answer
10 / 12 * 100 = 83.333… so 83.3. With the Percent format as well, the value is multiplied by 100 again and shows 8333.3%. Use only one of the two methods.
8. Group by Club with the count and total sessions for each club, and a grand total of sessions.
Show answer
Chess: 8 + 11 + 10 + 12 = 41, 4 members. Drama: 12 + 9 + 6 = 27, 3 members. Robotics: 12 + 7 + 5 = 24, 3 members. Grand total 41 + 27 + 24 = 92, 10 members.
9. A grouped report shows Robotics with a fee subtotal of RM120. What is wrong, and how do you find the cause?
Show answer
The correct subtotal is 3 * 60 = 180. The report is 60 short, so one Robotics member is missing. Count the Robotics rows (expect 3), find the absent name, then look for a leftover criterion or a hidden detail row. For example, Sessions > 5 would remove Jia.
10. The overall average sessions is shown as 9.2 and the Chess average as 10.5. Check both.
Show answer
Overall: 92 / 10 = 9.2, so that is correct. Chess: 41 / 4 = 10.25, so 10.5 is wrong. The correct value is 10.25, so check the formula and the records included.
If you got these wrong
- Questions 1 to 4 (wrong records or counts): revisit applying multiple query criteria correctly, especially brackets and the difference between > and >=.
- Question 5 (wrong order): see sorting records with a secondary key and check which key comes first.
- Questions 6 and 7 (calculation or format): go to creating a calculated field where supported.
- Questions 8 and 9 (grouping and totals): read grouping a report without hiding required values.
- Question 10 and any mismatch: use the routine in comparing displayed results with the source dataset.
Record your slips in the mistake log and retest queue, test queries in the read-only SQL practice lab, and check evidence with the ICT practical task and evidence checker.
A teacher can go through the questions you missed and the settings you chose, in online one-to-one ICT tuition.