SELECT
a.date,
COUNT(*) as daily_count,
(SELECT COUNT(*) FROM paypal_2014 b WHERE b.Item_ID != '' AND b.date <= a.date) as running_total
FROM
paypal_2014 a
WHERE
a.Item_ID != ''
GROUP BY
a.date
ORDER BY
a.date;
SELECT
a.date,
COUNT(*) as daily_count,
(SELECT COUNT(*) FROM paypal_2014 b WHERE b.Item_ID != '' AND b.date <= a.date) as running_total
FROM
paypal_2014 a
WHERE
a.Item_ID != ''
GROUP BY
a.date
ORDER BY
a.date;