This repository contains my solutions to SQL problems from DataLemur, written in MySQL.
Most DataLemur problems and their available solutions are in PostgreSQL. Since MySQL is also widely used in real-world scenarios, I decided to convert and solve these problems using MySQL to better understand the differences between the two.
- Solutions to DataLemur SQL questions (Free Tier)
- Queries written in MySQL syntax
- Use of CTEs, joins, window functions, and aggregations
This is a work in progress. Currently covering the free set of questions and will continue to add more.
- Practice SQL for interviews
- Understand PostgreSQL β MySQL conversions
- Build a consistent set of MySQL-based solutions
Some PostgreSQL functions are rewritten using MySQL equivalents (e.g., date handling, intervals, etc.).