Challenge No. 111: Generate all the numbers between From and To.
Solved using: SQL.
Custom Rank! Part 1
Challenge No. 106: Rank the countries based on Olympic medals, starting with the number of gold medals.
Solved using:Excel, Power Query, Python, and R.
Generate Concatenation Table
Challenge No. 110: Generate the result table.
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.
GADERYPOLUKI Cipher Apply
Challenge No. 109: GADERYPOLUKI Cipher
Column A needs to be changed on the basis of key given in column B.
Solved using: SQL.
Reverse Rows and Columns
Challenge No. 108: Reverse the rows and columns both.
Solved using: SQL.
Multiple Tables Lookup
Challenge No. 25: Lookup correct exchange rate & calculate Amt To.
Solved using: Power Query.
Count Palindromes in Range
Challenge No. 107: Palindrome numbers are those which are same even when read from backwards.
Solved using: Python in Excel.
Characters Repetition!
Challenge No. 105: In the question table, where some passwords are provided, extract the 6 most commonly used characters across all the passwords and count their repetitions.
Solved using:Excel (CONCAT, FILTER, GROUPBY), Google Sheets, Power Query (List.Combine, List.Distinct, List.Transform), Python, Python in Excel, and R.
Latest Date Shop Data
Challenge No. 106: Get the data for all shops corresponding to latest date as shown in the result table.
Solved using: Python in Excel.