SQL Interview Preparation: Solving Top Questions with Ease | 24 Daily Advanced SQL Practice

[@HARSHRAJ-gp6ve]

sir try to upload the questions regularly with cte as( select company_name, COUNT(CASE when year=2020 THEN 1 ELSE NULL END) AS 2020_sales, COUNT(CASE when year=2019 THEN 1 ELSE NULL END) AS 2019_sales FROM car_launches GROUP BY company_name ) select company_name,(2020_sales-2019_sales) as net_sales FROM cte ORDER BY (2020_sales-2019_sales) DESC;