SQL-da CTE-lardan foydalanishning ba'zi asosiy misollari: ustunning jami summasini hisoblash: SUM (SELECT order_id, order_date, order_total, SUM(order_total) OVER (ORDER BY order_date) AS running_total FROM orders) SELECT order_id, order_date, order_total, running_total FROM cumulative_sum; murakkab so'rovni bir nechta qadamlarga bo'lish: SUM (SELECT customer_info (SELECT customer_id, customer_name, city, state FROM customers ), order_info AS (SELECT order_id, customer_id, order_date, order_total) AS FROM customer_id. CTELECT order_customer_name, order_order_date, order_total, order_
spam fails_task lang_mismatch pii not_appropriate hate_speech sexual_content quality toxicity humor helpfulness creativity violence