How to make multiple where clause in SQL joins
SELECT cas.show_name,
COUNT(cac.show_id),
cas.status,
to_char("created_on", 'DD/MM/YYYY'),
to_char("publish_date", 'DD/MM/YYYY'),
cas.id
FROM colorcast_app_show as cas
LEFT OUTER JOIN colorcast_app_content as cac
ON cac.show_id = cas.id
AND cac.draft = false
WHERE cas.user_id=60
GROUP BY cas.id, cas.show_name;