Một nền tảng AI cho toàn bộ quy trình phân tích và chẩn đoán dữ liệu

-- Top 10 customers by total revenue
  -- NOTE: No tables were found in the provided schema.
  -- Please replace the placeholders below with your actual table and column names.
  SELECT
      customer_id,
      customer_name,
      SUM(revenue) AS total_revenue
  FROM
      `elton-data-public.your_dataset.your_table`  -- Replace with actual table
  WHERE
      -- Optional: filter by date range
      -- order_date BETWEEN '2024-01-01' AND '2024-12-31'
      1 = 1
  GROUP BY
      customer_id,
      customer_name
  ORDER BY
      total_revenue DESC
  LIMIT 10;