SUM

1
SELECT SUM(amount) as total_revenue
2
FROM `project.dataset.transactions`
3
WHERE DATE(transaction_date) = '2024-01-15';

1
SELECT
2
  product_category,
3
  SUM(quantity) as total_sold,
4
  SUM(amount) as total_revenue
5
FROM `project.dataset.sales`
6
GROUP BY product_category
7
ORDER BY total_revenue DESC;

1
SELECT
2
  SUM(amount) as total_sales,
3
  SUM(IF(payment_method = 'credit_card', amount, 0)) as credit_card_sales,
4
  SUM(IF(payment_method = 'bank_transfer', amount, 0)) as transfer_sales
5
FROM `project.dataset.transactions`;

1
SELECT
2
  order_date,
3
  amount,
4
  SUM(amount) OVER (ORDER BY order_date) as running_total
5
FROM `project.dataset.daily_sales`
6
ORDER BY order_date;