Given the statement "Then group according to the creditcode for all the cases where 'EITHER' the count is greater than 2 or the city or phone is not empty." in the Question, we know that EACH of the following fulfilled SHOULD be listed: 1. count(cust_id) is greater than 2 2. the city or phone is not empty So these are the "OR" relationship, for instance, the following extreme condition should be listed: a. count(cust_id) <= 2 but the city or phone is not empty b. count(cust_id) > 2 but the city and phone are both empty And since the WHERE query will process before aggregator and grouping/having queries, we cannot use WHERE query for this 'OR' relationship otherwise it will become an 'AND' relationship Hence the query should be: SELECT creditcode, count(cust_id) AS 'Number of Publishers' FROM publishers GROUP BY creditcode HAVING COUNT(cust_id) > 2 OR city IS NOT NULL OR phone IS NOT NULL ORDER BY creditcode;