Customer Sales analytics project that builds an ELT pipeline from raw CSVs into BigQuery and produces gold tables useful for tableau BI dashboards. Total revenue (price only): SELECT SUM(order_product ...
SELECT o.order_id, c.customer_name FROM orders o JOIN customers c ON o.customer_id = c.customer_id; ...