hi there and happy new year.
I need join two queries for output only, it's possible?... I tried with syntax CASE WHEN but I fail... can you help me?
sum(visitorcount) AS total
SUM(visitorcount) AS tot_CURRENT_MONTH,
MONTH (visitdate) AS MONTH
MONTH (visitdate) = MONTH (CURRENT_DATE())
AND YEAR (visitdate) = YEAR (CURRENT_DATE())