Microsoft SQL Server Code

SELECT NAME FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION > 120000;

Can anyone tell why can we not use having here

MYSQL SOLUTION

SELECT NAME FROM CITY WHERE COUNTRYCODE = 'USA' && POPULATION > 120000

select name from city where population>120000 and countrycode="usa"

Got it in the first try with

select name from city where population > 120000 and countrycode = 'USA';