Challenge No. 75: — This week will be FIFA World Cup week.
Solved using: SQL.
LAMBDA
Creates custom reusable functions in Excel.
Linear Interpolation!
Challenge No. 97: In the question table, the population data for cities A, B, and C are provided for different years.
Solved using:Excel, Google Sheets, Power Query, Python, Python in Excel, and R.
Avg Interval Between Wins
Challenge No. 74: — This week will be FIFA World Cup week.
Solved using: SQL.
Teams Repeated in Finals
Challenge No. 73: — This week will be FIFA World Cup week.
Solved using: SQL.
Consecutive Wins Within Span
Challenge No. 21: List the names who have won consecutively at least 3 times within a span of 180 days.
Solved using: Power Query.
Top 4 FIFA WC Champions
Challenge No. 71: — This week will be FIFA World Cup week.
Solved using: DAX.
Repeat Winners within 20 Years
Challenge No. 70: — This week will be FIFA World Cup week.
Solved using: SQL.
Consecutive FIFA Wins and Years
Challenge No. 69: — This week will be FIFA World Cup week.
Solved using: SQL.
Mismatch Fields Per Employee
Challenge No. 20: There are two rows per Emp ID which are from two different sources.
Solved using: Power Query (Table.AddColumn).
Find Palindromic Dates
Challenge No. 68: List the Palindrome dates in 21st century i.
Solved using: Python in Excel.