- 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:
HackerRank SQL Solution - Basic Select - Weather Observation Station 3
HackerRank SQL Solution - Basic Select - Weather Observation Station 1
- Query a list of CITY and STATE from the STATION table.
- The STATION table is described as follows:
HackerRank SQL Solution - Basic Select - Japanese Cities' Names
- Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.
- The CITY table is described as follows:
HackerRank SQL Solution - Basic Select - Japanese Cities' Attributes
- Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.
- The CITY table is described as follows:
HackerRank SQL Solution - Basic Select - Select By ID
- Query all columns for a city in CITY with ID 1661.
- The CITY table is described as follows:
HackerRank SQL Solution - Basic Select - Select All
- Query all columns (attributes) for every row in the CITY table.
- The CITY table is described as follows:
HackerRank SQL Solution - Basic Select - Revising the Select Query II
- Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is the USA.
- The CITY table is described as follows:
HackerRank SQL Solution - Basic Select - Revising the Select Query I
- Query all columns for all American cities in the CITY table with populations larger than 100000.
- The CountryCode for America is USA.
- The CITY table is described as follows:
CodeChef - Python Practice Solution - Waiting Time
Problem:
- The chef is eagerly waiting for a piece of information. His secret agent told him that this information would be revealed to him after K weeks.
- X days have already passed and Chef is getting restless now. Find the number of remaining days the Chef has to wait, to get the information.
- It is guaranteed that the information has not been revealed to the Chef yet.
CodeChef - Python Practice Solution - Chairs Requirement
Problem:
- Chef's coding class is very famous in Chefland.
- This year X students joined his class and each student will require one chair to sit on. Chef already has Y chairs in his class. Determine the minimum number of new chairs the Chef must buy so that every student is able to get one chair to sit on.
Subscribe to:
Posts (Atom)
You might also like
Deploy your Django web app to Azure Web App using App Service - F1 free plan
In this post, we will look at how we can deploy our Django app using the Microsoft Azure app service - a free plan. You need an Azure accoun...