Revising the Select Query II Hacker Rank Solution

Hello coders, In this post, you will learn how to solve the Revising the Select Query II Hacker Rank Solution. This problem is a part of the SQL Hacker Rank series.

Problem

Query the names of all American cities in CITY with populations larger than 120000. The CountryCode for America is USA.

Input Format

Revising the Select Query II hacker rank sql

The CITY table is described as follows:

Revising the Select Query II Hacker Rank Solution

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

Disclaimer: The above Problem (Revising the Select Query II ) is generated by Hackerrank but the Solution is Provided by Chase2Learn. This tutorial is only for Educational and Learning purposes.