Challenge No. 94: Extract the middle words in given data.
Solved using: SQL.
⭐️⭐️ Easy
Slightly challenging problems for learners.
Avg Cost Between City Pairs
Challenge No. 92: Find the average cost between the pair of cities.
Solved using: Python in Excel.
List Valid EAN-13 Numbers
Challenge No. 91: Provide a formula to list down all valid EAN-13 numbers.
Solved using: Python in Excel.
Get 4th Breakdown if >
Challenge No. 90: Find the 4th breakdown date of machines, only if total number of breakdowns > 4.
Solved using: Python.
Numbers with Odd Frequencies
Challenge No. 89: List the numbers which occur odd number of times.
Solved using: Python.
Analyse Data Using Financial Year
Challenge No. 20: Analyse the sales data by Financial Year and Financial Quaters
Assume the Financial year starts in April
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Region-Year with Max Growth
Challenge No. 87: Find the Region and Year where and when the growth was the highest.
Solved using: DAX.
Match Output to Picture
Challenge No. 83: Generate the output as shown in picture.
Solved using: SQL.
Top 4 Winner and Runner-up
Challenge No. 78: — This week will be FIFA World Cup week.
Solved using: SQL.
Top 5 Goal Scoring Teams
Challenge No. 75: — This week will be FIFA World Cup week.
Solved using: SQL.