OK... I'm sure I'm just blacking out...
I have data as follows
I'm trying to get a pie chart to break down the sums of 0-3, 3-5, 5-10 throughout the dates.
Meaning it would look like this:
How would I run that query?
Answer...
SELECT '0-3' as times, SUM(0-3) as sums FROM table
UNION ALL
SELECT '3-5' as times, SUM(3-5) as sums FROM table
UNION ALL
SELECT '5-10' as times, SUM(5-10) as sums FROM table