gamito
4/21/2015 - 10:00 PM

Contas do Trail agrupadas por valor

Contas do Trail agrupadas por valor

SELECT ppl_mode, ppl_value,COUNT(ppl_value) as ppl, SUM(ppl_value) as totalprice
FROM tvp_2016 
where ppl_number IS NOT NULL AND ppl_mode = 'TC'
GROUP BY ppl_value WITH ROLLUP