Solving a Complex SQL Interview Problem | Find the Most Modified File Extension

In this video let's solve a intermediate/complex sql interview query. The problem was shared during a recent sql interview. We are given a table with file extensions and we need to find the most modified file extension using SQL.

Download the dataset from below:

Previous
Previous

SQL Interview Query for Data Analyst

Next
Next

SQL JOINS Interview Question | What does different SQL Joins return?