SQL Computeby
Computeby
use pubs
go
-- USE THIS SCRIPT AFTER SETTING UP DATA WITH cube3.sql
select units_sold,model,year,color
from automobile_sales_detail
order by model,year,color
compute sum(units_sold) by model,year
compute sum(units_sold) by model
go