Back to the full dot-point answer
ScotlandComputer ScienceQuick questions
Area 3: Database Design and Development
Quick questions on SQL querying: SELECT, joins, aggregates and GROUP BY - SQA Higher Computing Science
2short Q&A pairs drawn directly from our worked dot-point answer. For full context and worked exam questions, read the parent dot-point page.
What is q1?Show answer
State the SQL clause used to filter which records a query returns. [1 mark]
What is q3?Show answer
State the purpose of GROUP BY when used with an aggregate function. [2 marks]
Have a question we have not covered?
This dot-point answer is short enough that we have not extracted many short questions yet. Read the full dot-point answer or ask Mo, our study assistant, in the chat for follow ups.