How to create a SQL query according to the following scheme?

Question

SQL

According to the existing database schema, which has the following tables: stock (cars for sale), shop (dealerships), mark (models), manufacturer (car manufacturer), create a query for all car manufacturers (manufacturer.name), indicating how many specific cars for sale at each dealership in descending order. Also, take into account that for some manufacturers there may not be records in the stock table, while these manufacturers must be present in the final selection

Answer 1

LEFT JOIN, GROUP BY, COUNT(), SORT BY