3. Solution of Hacker Rank Weather Observation Station 4.
Author: neptune | 23rd-Jan-2023
Weather Observation Station 4
Problem Statement : Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table.
The STATION table is described as follows:
where LAT_N is the northern latitude and LONG_W is the western longitude.
For example, if there are three records in the table with CITY values 'New York', 'New York', 'Bengalaru', there are 2 different city names: 'New York' and 'Bengalaru'.
Answer will be (Total cities) - (Unique cities)=3-2=1
Solution :
For this challenge, we must:
Use a Count() aggregate function to count the cities.
Use a Count() again to find Distinct cities then subtract.
Query :
SELECT Count(CITY) - Count(Distinct (CITY))
FROM STATION;
Output:
Hope you understand !!!
If you have any questions let me know in the comment section.
#JavaScript #Python #Hackerrank #Motivation #AI #React.js #Interview #Testing #SQL #Selenium #LeetCode #Problem Solving #Machine learning #IT #API #Java #GPT #AWS #Algorithms #Github #Projects #Jobs #Django #Microservice #Certifications #Node.js #TCS #Google #Story #Pip #Data Science #Postman #Health #Twitter #Elon Musk
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...
Modified 0-1 knapsack problem | Frsco Play HackerrankAuthor: neptune | 05th-Nov-2023
#Hackerrank #Problem Solving
An automobile mechanic wants to buy a set of spare parts from a manufacturing unit. Goal is to maximise the amount of money the mechanic can earn...
AngularJS - Know Tech Frameworks | Fresco PlayAuthor: neptune | 05th-Nov-2023
#Hackerrank #Problem Solving
Build an application that displays the framework details using AngularJS routing. We will build an application that displays the Tech Frontend and Backend frameworks...
30+ SQL Interview QuestionsAuthor: neptune | 05th-Jan-2023
#Interview #SQL
Data Definition Language (DDL) – It allows end-users to CREATE, ALTER, and DELETE database objects...
PySpark Milestone Black Friday Sales Data | Fresco Play HackerrankAuthor: neptune | 05th-Nov-2023
#Data Science #Hackerrank
Welcome to the Spark Challenge. You are provided with the Black Friday sales data and we as a big data developer needs to analyze and fetch the required data...
Python - Number Based Problem | HackerrankAuthor: neptune | 17th-Aug-2023
#Hackerrank #Problem Solving
Determine whether the number in descending order is a prime or not. If the number is a prime, then print "Sorted Number is a prime number," otherwise, print "Sorted Number is not a prime number."..
View More
anonymous | May 26, 2024, 10:18 p.m.
THIS IS WORKING IN THE MYSQL SERVER BUT NOT INTO SQL