Di dieu aya sababaraha conto dasar ngagunakeun CTEs di SQL: Ngitung jumlah kumulatif tina kolom: WITH cumulative_sum AS (SELECT order_id, order_date, order_total, SUM(order_total) OVER (order BY order_date) AS running_total FROM pesenan ) SELECT order_id, order_date, order_total, running_total FROM cumulative_sum; Ngabobolkeun query rumit kana sababaraha léngkah: WITH customer_info AS (SELECT customer_id, customer_name, kota, nagara FROM customer ), order_info AS (order BY order_id, customer_id, order_date, order_total order SELECT order) SELECT customer_info.com_name, order_date, order_total order SELECT order SELECT
spam fails_task lang_mismatch pii not_appropriate hate_speech sexual_content quality toxicity humor helpfulness creativity violence