Dec 7, 2025 · 1 min read · Question and Answer: Key Points: What the Query Does Retrieves the CITY and STATE fields for every row in the STATION table Key SELECT Fields Only CITY and STATE are requested (not other columns) Why It Works No WHERE condition → returns all st...
Join discussionDec 7, 2025 · 1 min read · Question and Answer: Key Points: What the Query Does Selects the NAME of every city located in Japan Key Condition COUNTRYCODE = 'JPN' filters rows to only Japanese cities Why It Works Only the NAME column is returned, exactly as the problem as...
Join discussionDec 6, 2025 · 1 min read · Question and Answer: Key Points: What the Query Does Retrieves all columns for every city located in Japan Key Conditions Used COUNTRYCODE = 'JPN' filters only Japanese cities Why It Works SELECT * returns the complete details of each matching ...
Join discussionDec 6, 2025 · 1 min read · Question and Answer: Key Points: What the Query Does Fetches all columns for the city with ID = 1661 Key Conditions Used WHERE ID = 1661 ensures we only retrieve the specific city requested Why It Works SELECT * returns all available fields (ID...
Join discussionDec 6, 2025 · 1 min read · Problem: https://www.hackerrank.com/challenges/revising-the-select-query-2 Question: Code: SELECT NAME FROM CITY WHERE COUNTRYCODE='USA' AND POPULATION>120000 Key Points: What the Query Does Retrieves the names of U.S. cities Only cities...
Join discussionAug 8, 2025 · 2 min read · I’m so happy to share that I have earned my first silver badge in 30 days of code challenge offered by HackerRank. What made me happy wasn’t the silver badge itself, it is my consistency that I have maintained to keep in track of practicing python fo...
Join discussion
Aug 4, 2025 · 3 min read · print("HELLO") Today's post is divided into two parts - My 30 days challenge of HackerRank - and finally figuring out GitHub I have joined 30 days challenge of HackerRank.I reccomend all of you to try it. Because even for the laziest of lazy people,...
Join discussion
Jul 28, 2025 · 2 min read · 🎯 Objective In this challenge, you'll practice using conditional statements (if, else if, else) to control the program flow based on input values. 🧠 Problem Statement Given an integer N, apply the following rules: If N is odd, print "Weird". If ...
Join discussionJul 28, 2025 · 2 min read · In this post, we’ll solve a classic HackerRank problem that tests your understanding of basic arithmetic operations, percentages, and rounding in C#. It’s a great warm-up for anyone looking to sharpen their logic-building and syntax skills. 🧠 Proble...
Join discussion
