SELECT .... allows you to show certain data from a table. This is the equivalent of PRINT from languages such as C# or Python
Have a go at these exercises:
select *
from car_sales
where sold_price > 50000
select make, model, sold_price
from car_sales
where sold_price > 50000
select *
from car_sales
where make = 'seat' or make = 'ferrari'
select *
from car_sales
where make IN ('seat','ferrari')
select sum(sold_price)
from car_sales
select make, (sold_price - purchase_price)
from car_sales
select count(*)
from car_sales
select *
from car_sales
where sold_date > '20210101'
EXAM TIP: It is unlikely that you will need to write a SELECT statement for a single table. However it is highly likely that you will need to write an advanced SELECT statement (to join two tables).
SELECT statements are defined on the AQA Specification. It also explicitely states that "Exam questions will require that data is extracted from no more than two tables for any one query. ". Learn this!!