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