Software Engineering › Key terms › Code patterns › SQL relational and logical operators
SQL relational and logical operators
Code pattern Code patterns
Definition
Relational operators: CONTAINS, DOES NOT CONTAIN, EQUALS, NOT EQUAL TO, GREATER THAN (OR EQUAL TO), LESS THAN (OR EQUAL TO). Logical operators: AND, OR, NOT. Put text and dates in quotes.
Example
WHERE Name CONTAINS 'war' AND Cost < 50Found in: course specifications, 2025 HSC marking guidelines, past SDD papers.
Where it is used in the test
Syllabus area: Code patterns.
Question types it can appear in
- SQL: Write or read it in the SQL query tool.
- Code reading: Code or algorithm reading: interpret a fragment and state its output or purpose.
Where it has appeared in the paper
Programming for the Web (Part A). Part letters follow each paper’s own layout.
Related past questions
- 2025 HSC Q21 (4 marks): SQL queries Programming for the Web (Part A) · 4 marks
These are the questions the flashcard set links to this term. Open each one and compare your answer with its marking criteria.
Study links
- Flashcard: SQL relational and logical operators in Code Patterns: Pseudocode, Python, SQL, CSS (Years 11 and 12) · study that set
- Memorise: SQL: HSC syntax and must-know queries
How to use it in an answer
A model sentence
Code pattern: “Relational operators: CONTAINS, DOES NOT CONTAIN, EQUALS, NOT EQUAL TO, GREATER THAN (OR EQUAL TO), LESS THAN (OR EQUAL TO).” Then apply it: WHERE Name CONTAINS 'war' AND Cost < 50
In a short answer, give the definition in your own words first, then tie it to the situation in the question. Do not copy the example above unless it fits the scenario.
Technique for the question types
- SQL: Use SELECT, FROM, WHERE, GROUP BY, ORDER BY in order; put text in quotes; combine conditions with AND or OR; name the right tables.
What the marking guidelines and feedback say
Note: the sample does not filter Category to Software/Hardware (the table is assumed to have only those two). Adding AND (Category = 'Software' OR Category = 'Hardware') is safe. Marker feedback: query must run; quotation marks around data being searched; use OR/AND in WHERE; correct GROUP BY and ORDER BY fields.
Worked answers from the marking guidelines
2025 HSC Q21 (4 marks): SQL queries (4 marks): criteria and sample answer
Criteria
4: Correct SQL query that extracts 'Pending' and 'Escalated' jobs for the 'Software' and 'Hardware' categories, counts the jobs for each status in each category, and outputs results in descending order. 3: Addresses most requirements. 2: Some understanding of the problem. 1: Some understanding of SQL or the problem.
Sample answer
SELECT Category, Status, COUNT(JobID) AS Jobs FROM Issues WHERE (Status = 'Pending' OR Status = 'Escalated') GROUP BY Status, Category ORDER BY Jobs DESC
Common mistakes
- 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.
- Use the term exactly as the syllabus words it, then link it to the scenario in the question; the 2025 feedback repeatedly rewards using the stimulus.
- Answer the command word: outline gives main points only, explain gives a reason or cause, discuss gives both sides.
Related terms
Same group in the syllabus: SQL statement structure · SQL calculated aggregate with GROUP BY · CSS rule syntax · XSS JavaScript fragment reading · Shell script pattern