HackerRank SQL Preparation: Revising the Select Query I(MySQL)

Problem Statement:

Query all columns for American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA.

Link:HackerRank - Revising the SELECT Query

Solution:

SELECT * FROM CITY WHERE POPULATION > 100000 AND COUNTRYCODE = 'USA';

Explanation:

This SQL query retrieves all columns () for cities in the **CITY* table where the population is greater than 100000 and the CountryCode is 'USA'. Here's a breakdown of each part:

• 
  SELECT *: Selects …

america american cities city hackerrank link mysql preparation problem query select solution sql sql query statement usa writeups