2. Solution of Hacker Rank Weather Observation Station 3.

Author: neptune | 23rd-Jan-2023
🏷️ #SQL #Hackerrank

Weather Observation Station 3

Problem Statement : Query a list of CITY names from STATION for cities that have an even ID number. 

Print the results in any order, but exclude duplicates from the answer.

The STATION table is described as follows:





Solution :

For this challenge, we must:

  1. Select a unique city column using the Distinct (CITY).

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

    • ID should be even, Example : 122, 1234, 2346.


Query :


SELECT Distinct(CITY) 

FROM STATION

WHERE 

    (ID%2)= 0;


Output:



Hope you understand !!!

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




👉 Read More
The Blunder | Hackerrank
5. Solution of Hacker Rank Weather Observation Station 8.
7.Solution of Hacker Rank The Report
Identifying the Odd One Out in a Series of Strings | Hackerrank
4. Solution of Hacker Rank Weather Observation Station 6.
3. Solution of Hacker Rank Weather Observation Station 4.
The PADS | Hackerrank
6. Solution of Hacker Rank Employee Salaries.
1. Basic SQL Select Query of Hacker Rank.
Generate Fibonacci Sequence - JavaScript | Hackerank
Team Formation Hackerrank | Julia
Modified 0-1 knapsack problem | Frsco Play Hackerrank
Weather Observation Station 18 | Hackerrank
Solving the Ice Cream Parlor Problem | Hackerrank
AngularJS - Know Tech Frameworks | Fresco Play
PySpark Milestone Black Friday Sales Data | Fresco Play Hackerrank
30+ SQL Interview Questions
Backspace String Compare using R | Fresco Play
Top Earners | HackerRank
Python - Number Based Problem | Hackerrank
Explore more Blogs...