select qtr, sum(pricepaid) as qtrsales,
(select sum(pricepaid)
from sales join _date on sales.dateid=_date.dateid
where qtr='1' and year=2008) as q1sales
from sales join _date on sales.dateid=_date.dateid
where qtr in('2','3') and year=2008
group by qtr
order by qtr;