Data cleaning on a global tech layoffs dataset using MySQL
-
Updated
May 19, 2026
Data cleaning on a global tech layoffs dataset using MySQL
Advanced MongoDB Atlas aggregations on the `sample_mflix` database. Queries include top actors by movie count, filtering by languages and viewer ratings, comparing array sizes, and ranking movies by awards. Demonstrates `$unwind`, `$group`, `$setWindowFields`, `$expr`, and array operations.
Practice projects and exercises showcasing my SQL skills, including advanced queries, optimization, and real-world applications
This repository contains solutions to the "Advanced SQL Queries and Aggregations" assignment. The SQL queries demonstrate usage of aggregation functions, grouping, sorting, and filtering in MySQL.
MongoDB Atlas aggregation queries using `$lookup` to join `comments`, `movies`, and `users` collections. Tasks include retrieving fully joined comment data and re-implementing a global average viewer rating filter without `$setWindowFields`.
End-to-end SQL analytics project on NYC restaurant delivery data using PostgreSQL
Add a description, image, and links to the advanced-queries topic page so that developers can more easily learn about it.
To associate your repository with the advanced-queries topic, visit your repo's landing page and select "manage topics."