Challenge No. 37: Create the list of Families and their members from the given names.
Solved using: SQL.
ExcelBI Power Query Challenges
Including all the Power Querry challenges designed by Excel BI.
Match employee names using wildcard
Challenge No. 36: There are two tables.
Solved using: SQL.
Insert blank rows based on
Challenge No. 35: Insert the number of blank rows after the records as per Number column.
Solved using: Python.
Generate Cartesian product of values
Challenge No. 34: Generate the Cartesian product as shown.
Solved using: SQL.
List max frequency alphabets across
Challenge No. 33: Generate the answer as shown.
Solved using: SQL.
Form quarterfinal pairs by FIFA
Challenge No. 32: — This is the last problem in the series of FIFA world cup challenges.
Solved using: SQL.
Identify FIFA father-son pairs by
Challenge No. 31: — This is the second last problem in the series of FIFA world cup challenges —
Identify the father son duo from the data set of FIFA World cups (some data changed).
Solved using: SQL.
Format FIFA data with hyphens
Challenge No. 30: — This week is for FIFA world cup challenges —
Insert a hyphen ( i.
Solved using: SQL.
Find max finals gap for
Challenge No. 29: — This week is FIFA world cup challenges —
If a country has appeared more than once in finals, find the maximum gap in years for next – previous appearance for that country.
Solved using: SQL.
Repeat Greek alphabets to match
Challenge No. 28: You will need to see which Greek alphabet appears maximum no.
Solved using: Power Query.