SELECT a.`demographic_no`,`last_name`,`first_name`,`phone`,`provider_no` , COUNT( DISTINCT ( `DESCRIPTION` ) ) AS c FROM `allergies` a, `demographic` d WHERE a.`demographic_no`=d.`demographic_no` AND `patient_status`="AC" GROUP BY `demographic_no` ORDER BY c DESC;