Cacher is the code snippet organizer for pro developers

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