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.

CodeChef - Python Practice Solution - Burgers

Problem:

• The chef is fond of burgers and decided to make as many as possible.
• The chef has A patties and B buns. To make 11 burgers, Chef needs 11 patties and 11 buns.
• Find the maximum number of burgers that the Chef can make.

CodeChef - Python Practice Solution - Age Limit

Problem:

• Chef wants to appear in a competitive exam. To take the exam, there are the following requirements:
• The minimum age limit is X (i.e. Age should be greater than or equal to X).
• Age should be strictly less than Y.
• The chef's current Age is A. Find whether he is currently eligible to take the exam or not.

HackerRank Python Solution - Regex and Parsing - Re.split()

• You are given a string s consisting only of digits 0-9, commas ,, and dots .
• Your task is to complete the regex_pattern defined below, which will be used to re.split() all of the , and . symbols in s.
• Every comma and every dot in s is guaranteed to be preceded and followed by a digit.

Sample Input:

100,000,000.000