Algorithm


Problem Name: Sql - Revising the Select Query I

Problem Link: https://www.hackerrank.com/challenges/revising-the-select-query/problem?isFullScreen=true

In this HackerRank Functions in SQL problem solution,

Query a count of the number of cities in CITY having a Population larger than 100000.

.

Input Format

The CITY table is described as follows:

 

Code Examples

#1 Code Example with SQL

Code - SQL


SELECT COUNT(*) FROM CITY
WHERE POPULATION > 100000;
Copy The Code & Try With Live Editor
Advertisements

Demonstration


Previous
[Solved] Type of Triangle in SQL solution in Hackerrank
Next
[Solved] Revising Aggregations - The Sum Function in SQL solution in Hackerrank