1. Buyurtmalar: - order_date datetime NULL emas - user_id int NULL emas - order_id int NULL emas 2. Mahsulotlar: - order_id int NULL emas - model int NULL emas - cat_1 varchar(50) NULL emas - price int NULL emas - quantity int NULL emas cat_1 qiymatlari: - Kiyim-kechak - Poyabzal - Kosmetika - Uy uchun mahsulotlar - O'yinchoqlar 2021 yilda "Kiyim-kechak" kategoriyasidagi va 2022 yilda "Poyabzal" kategoriyasidagi buyurtmalar va "kerakli kategoriyadagi mahsulotlar" sonini ko'rsating (oxirgi ko'rinish: 2 satr. Maydonlar: yil, mahsulotlar soni, buyurtmalar soni) with cte as( select year(o.order_date) as year_orders, g.cat_1, count(distinct o.order_id) as count_orders, sum(g.quantity) as count_quan from Orders o join Goods g on o.order_id = g.order_id where g.cat_1 = 'Kiyim-kechak' and Year(o.order_date) = 2021 or g.cat_1 = 'Poyabzal' and Year(o.order_date) = 2022 group by year_orders, g.cat_1 ) select year_orders, count_quan, count_orders from cte