test.sql

SELECT 
  cars.style, 
  SUM(cars.cost_$) AS Revenue,
  YEAR(sales.purchase_date) AS Purchase_Year
FROM sales
INNER JOIN cars ON sales.car_id = cars.car_id
WHERE cars.style = 'SUV' AND YEAR(sales.purchase_date) = '2022';