SELECT CURDATE() as "Date",CONCAT("Number of active designated patients in clinic ",count(d.demographic_no) ) as "" FROM demographic d WHERE patient_status = 'AC'