group

select 
 t.startstncode
 ,sum(t.price100)
from mp_sales t
group by t.startstncode

select 
t.startstncode
,t.tickettype
,sum(t.price100)
from mp_sales t
group by t.startstncode ,t.tickettype
order by t.startstncode,t.tickettype

select 
 t.startstncode
 ,sum(t.price100)
from mp_sales t
group by rollup (t.startstncode)

select 
t.startstncode
,t.tickettype
,sum(t.price100)
from mp_sales t
group by rollup(t.startstncode ,t.tickettype)
order by t.startstncode,t.tickettype

select 
t.startstncode
,sum(t.price100)
from mp_sales t
group by CUBE(t.startstncode)

select 
t.startstncode
,t.tickettype
,sum(t.price100)
from mp_sales t
group by CUBE(t.startstncode ,t.tickettype)
order by t.startstncode,t.tickettype

select 
grouping(t.startstncode)
 ,t.startstncode
 ,sum(t.price100)
from mp_sales t
group by rollup (t.startstncode)

select 
decode(grouping(t.startstncode),1,'all stations',t.startstncode)
--,t.startstncode
,decode(grouping(t.tickettype),1,'all tickettype',t.tickettype)
--,t.tickettype
,sum(t.price100)
from mp_sales t
group by rollup(t.startstncode ,t.tickettype)
order by t.startstncode,t.tickettype


select 
decode(grouping(t.startstncode),1,'all stations',t.startstncode)
--,t.startstncode
,decode(grouping(t.tickettype),1,'all tickettype',t.tickettype)
--,t.tickettype
,sum(t.price100)
from mp_sales t
group by CUBE(t.startstncode ,t.tickettype)
order by t.startstncode,t.tickettype


select 
 t.startstncode
 ,sum(t.price100)
from mp_sales t
group by grouping sets (t.startstncode)

select 
t.startstncode
,t.tickettype
,sum(t.price100)
from mp_sales t
group by grouping sets(t.startstncode ,t.tickettype)
order by t.startstncode,t.tickettype


select 
 t.startstncode
 ,grouping_id(t.startstncode)
 ,sum(t.price100)
from mp_sales t
group by cube(t.startstncode)

select 
t.startstncode
,t.tickettype
,grouping_id(t.startstncode,t.tickettype)
,sum(t.price100)
from mp_sales t
group by cube(t.startstncode ,t.tickettype)
order by t.startstncode,t.tickettype

select
 *
from mp_sales t