Certainly! Here is the SQL query in markdown format:

CREATE INDEX idx_population ON city(population);
CREATE INDEX idx_countrycode ON city(countrycode);

SELECT name
FROM city
WHERE 
    population > 120000 AND 
    countrycode = 'USA';

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

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

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

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