sample sql luciddb

gistfile1.sql

select 'Last 30 Days', sum(measure1)
from time t, fact f
where f.timeid = t.timeid
and
f.date between applib.add_days(current_date, -30) and current_date
UNION ALL
select 'Current Month', sum(measure1)
from time t, fact f
where f.timeid = t.timeid
and t.month = applib.extract_timestamp(current_timestamp, 'MONTH')+1
and t.year = applib.extract_timestamp(current_timestamp, 'YEAR')
UNION ALL
select 'Previous Month', sum(measure1)
from time t, fact f
where f.timeid = t.timeid
and t.month = applib.extract_timestamp( (current_timestamp - INTERVAL '1' month), 'MONTH')+1
and t.year = applib.extract_timestamp( (current_timestamp - INTERVAL '1' month), 'YEAR')