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`.

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.