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

HackerRank Python Solution - Regex and Parsing - Detect Floating Point Number

• You are given a string N.
• Your task is to verify that N is a floating-point number. 
• In this task, a valid float number must satisfy all of the following requirements:
• Number can start with +, - or . symbol.
• For example: 
• ✔+4.50
• ✔-1.0
• ✔.5
• ✔-.7
• ✔+.4
• ✖-+4.5
• Number must contain at least 1 decimal value.

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 account, Visual Studio Code editor, and your developed Django App to follow the below steps. If you don't have an Azure account, you can create a free account by going to this URL Microsoft Azure

I have developed a simple web app using Django, which renders an HTML page to explain this topic. If you have a dependency on databases like Postgres or Azure storage, those also need to be configured. 

Create a Web App in Azure:

Let's first start with setting up the app service plan in Azure.