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.
-
Updated
Sep 16, 2025
#
advanced-queries
Here are 4 public repositories matching this topic...
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`.
mongodb backend pipeline nosql homework lookup aggregation cross-collection aggregations mongodb-atlas advanced-queries data-joining
-
Updated
Dec 6, 2025 - TypeScript
Practice projects and exercises showcasing my SQL skills, including advanced queries, optimization, and real-world applications
-
Updated
Sep 9, 2025
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.
mongodb backend nosql homework ranking data-analysis aggregation-pipleline mongodb-atlas window-functions advanced-queries
-
Updated
Dec 4, 2025 - TypeScript
Improve this page
Add a description, image, and links to the advanced-queries topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the advanced-queries topic, visit your repo's landing page and select "manage topics."