How to find the number of cars sold of each brand?

Question

SQL

How to find the number of cars sold of each brand?
2 tables: CAR, DEAL. CAR: id, model, marque; DEL: id, name_client, id_care; output format: marque, count_car

Answer 1

SELECT marque, COUNT(*) AS count_car
  FROM CAR
    INNER JOIN DEL ON id_care = CAR.id
  GROUP BY marque