Revising the Select Query II

  • + 0 comments

    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';