-- 1. CTE BÁSICA — Ventas por región WITH ventas_por_region AS ( SELECT region, COUNT(*) as total_ventas, SUM(monto) as total_monto, AVG(monto) as promedio_monto FROM ventas GROUP BY region ) SELECT * ...
--windows functions are really powerful and are somewhat like a group by - except they don't roll everything up into 1 row when grouping. --windows functions allow us to look at a partition or a group ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results