1. Basic SQL Select Query of Hacker Rank.

Author: neptune | 20th-Apr-2022
🏷️ #SQL #Hackerrank

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

The CITY table is described as follows:







Solution :

For this challenge, we must:

  1. Select all columns using the all-column wildcard (*).

  2. Restrict the selected rows using the WHERE clause so that only records satisfying both of the following two conditions are returned:

    • COUNTRYCODE is USA, meaning the cities are American.

    • POPULATION is greater than 100000.


Query :


SELECT * 

FROM CITY 

WHERE 

    COUNTRYCODE = 'USA' 

    AND POPULATION > 100000;


Output:



Hope you understand !!!

If you have any questions let me know in the comment section.


🏷️ Discover your Interest

#JavaScript #AI #Python #Hackerrank #Motivation #React.js #Interview #Testing #IT #SQL #Selenium #Machine learning #LeetCode #TCS #AWS #Problem Solving #Certifications #API #Java #GPT #Algorithms #Github #Projects #Jobs #Django #Microservice #Node.js #Google #Story #Data Science #Health #Twitter #Elon Musk #ML #IELTS