Revising Aggregations – The Count Function Solution
Hello Friends in this article i am gone to share Hacker Rank SQL Solutions with you | Revising Aggregations – The Count Function Solution
Also Visit: New Companies Solution
Query a count of the number of cities in CITY having a Population larger than 100,000.
The CITY table is described as follows:
Solution – Revising Aggregations – The Count Function
SELECT COUNT(*) FROM CITY WHERE POPULATION > 100000
What do you mean by aggregation in SQL?
SQL aggregation is the task of collecting a set of values to return a single value. It is done with the help of aggregate functions, such as SUM, COUNT, and AVG. For example, in a database of products, you might want to calculate the average price of the whole inventory.
The COUNT function
Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5.
Disclaimer: The above Problems are generated by Hacker Rank but the Solutions are Provided by NYANDER.COM. All Hacker Rank SQL Solutions Shared only for Educational and Learning Purpose.