Challenge No. 92: Find the average cost between the pair of cities.
Solved using: Python in Excel.
Table.Group
Groups rows in a table based on specified columns and applies aggregations in Power Query.
Numbers with Odd Frequencies
Challenge No. 89: List the numbers which occur odd number of times.
Solved using: Python.
Duplicate Values! Part 1
Challenge No. 100: Consider the IDs in the question table.
Solved using:Excel (CHAR, COUNTIF, COUNTIFS), Google Sheets, Power Query (List.Transform, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Match Output to Picture
Challenge No. 83: Generate the output as shown in picture.
Solved using: SQL.
Top 5 Goal Scoring Teams
Challenge No. 75: — 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.
Last Inventory Level!
Challenge No. 95: In the Question table, monthly inventory levels of products are provided.
Solved using:Excel (BYROW, FILTER, HSTACK), Google Sheets, Power Query (List.RemoveNull, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Two-Column Text!
Challenge No. 94: In the question table, texts are provided for different groups.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Split, List.Transform, Table.ExpandTableColumn), Python, Python in Excel, and R.
Find Matches with Same Goals
Challenge No. 61: List the matches where total goals scored are same.
Solved using: Excel VBA.
Random Selection! Part 1
Challenge No. 93: Randomly select a staff member from each department.
Solved using:Excel (FILTER, HSTACK, INDEX), Google Sheets, Power Query (Table.Group), Python, Python in Excel, and R.