Bir nechta jadval va murakkab shartlarni o'z ichiga olgan murakkab SQL so'rovini tuza olasizmi?

sql -- Murakkab SQL so'rovi misollar, bir nechta jadvallar bilan shartlar bilan SELECT u.id AS user_id, u.name AS user_name, o.order_id, o.order_date, p.product_name, od.quantity FROM users u JOIN orders o ON u.id = o.user_id JOIN order_details od ON o.order_id = od.order_id JOIN products p ON od.product_id = p.product_id WHERE u.status = 'active' AND o.order_date BETWEEN '2023-01-01' AND '2023-12-31' AND p.category IN ('Electronics', 'Books') AND od.quantity > 1 ORDER BY o.order_date DESC LIMIT 100;

Ushbu so'rovda biz faol foydalanuvchilarni, 2023 yildagi buyurtmalarini, buyurtma tafsilotlarini va ma'lum kategoriyadagi mahsulotlarni tanlaymiz, miqdorga qarab filtrlash va buyurtma sanasiga ko'ra tartiblaymiz.