Single-Table Queries Flashcards

1️⃣ Familiarise yourself with the flashcards:

Look through all the flashcards to see what's on both sides.
Make sure you understand the information on each card. If something's unclear, click the link to the revision notes at the bottom of the page for more details.

2️⃣ Test yourself:

Look at the question or prompt on each card and try to remember the answer before flipping it over.
Check the answer and make a note of any cards you find challenging and need to go over more.

3️⃣ Consistently Review and Practice:

Use spaced repetition: spend more time on the cards you struggle with and go over them more often.
Regularly review all the flashcards to help you better understand and retain the information over time.

Note: We may include questions that have multiple correct answers. It's useful to remember specific examples to understand these concepts better.

PERSONALISED 1-TO-1 TUTORING

Get support with clear explanations, practice and feedback (Ages 5 to 16).

Want an ad-free experience? Subscribe to remove ads

What does SELECT do in a single-table query?

It picks which columns to show.

It names the table to get the data from.

It filters rows so only those meeting a condition are shown.

Use ORDER BY a column. Add ASC for ascending or DESC for descending.

AND combines, OR allows either, and NOT reverses a condition.

It matches text to a pattern.

% means any number of characters. _ means one character.

Use DISTINCT before the column name.

The number of rows that match the query.

The average of the numbers in that column.

Put an expression in SELECT and name it with AS, for example price*qty AS total.

Put text in single quotes, for example 'London'.