TK Study

Software Engineering › Key terms › Command words › SQL questions

SQL questions

Process Command words

Definition

Use SELECT, FROM, WHERE, GROUP BY, ORDER BY in order; put text in quotes; combine conditions with AND or OR; name the right tables.

Example: 2025 Q21.

Found in: syllabus, course specifications, 2025 HSC marking guidelines, sample exam and familiarisation guidelines, school notes.

Where it is used in the test

Syllabus area: Command words.

Question types it can appear in

Past questions of this type in the bank

Study links

How to use it in an answer

How to approach it

Technique from the syllabus and marking guidelines

Use SELECT, FROM, WHERE, GROUP BY, ORDER BY in order; put text in quotes; combine conditions with AND or OR; name the right tables.

Pattern: 2025 Q21.

Tips

Marker feedback on other questions of the same type (code and diagram feedback often applies across questions)
  • SQL questions (2025 HSC exam Q21): query must run; quotation marks around data being searched; use OR/AND in WHERE; correct GROUP BY and ORDER BY fields.
General advice
  • Answer the command word: outline gives main points only, explain gives a reason or cause, discuss gives both sides.

Same group in the syllabus: Multiple choice (MC) · Multi-select · Drag-and-drop ordering · Fill in the blanks and dropdowns · Matching and tables · Drawing questions (online tool) · Pseudocode questions · Python questions · Short-answer questions · Extended response (5 to 6 marks) · Reading time