How to execute query in SQL task?

Question

SQL

ownload/67963667_cc538eb9ac0e41b743456558c706d2d4_800.jpg" alt="image"/>

Answer 1

one)

SELECT b.BrandName FROM Auto a 
LEFT JOIN Brand b ON b.BrandId = a.BrandId
GROUP BY a.BrandId ORDER BY AVG(a.PRICE) DESC
LIMIT 1;

2)

SELECT COUNT(a.AutoId) FROM Auto a
LEFT JOIN Brand b ON b.BrandId = a.BrandId
WHERE b.BrandCountry="DE";

3)
I can't think