As you see, there is no data from 02/12 to 02/18, but I want to display 0’s on them.
I have set “null value” to “null as 0”
Can anyone help me to deal with the problem?
the query code:
SELECT STR_TO_DATE(DATE_FORMAT(ap.created_on, ‘%Y-%m-%d’), ‘%Y-%m-%d’) AS time, count(distinct account_id) AS ‘Registrations’
FROM account as a inner join account_profile as ap on a.email_address = ap.email_address
WHERE ap.created_on < curdate() AND ap.created_on >= DATE_SUB(curdate(), INTERVAL 14 day) and ap.is_guest=“AA==”
group by DATE_FORMAT(ap.created_on, ‘%Y-%m-%d’)
;