SQL50-Leetcode

This repository contains the solutions for the SQL questions as organised in the Leetcode

LeetCode Topics

Database

0197-rising-temperature
0570-managers-with-at-least-5-direct-reports
0577-employee-bonus
0584-find-customer-referee
0595-big-countries
0620-not-boring-movies
1153-product-sales-analysis-i
1161-project-employees-i
1182-game-play-analysis-iv
1245-user-activity-for-the-past-30-days-i
1258-article-views-i
1292-immediate-food-delivery-ii
1317-monthly-transactions-i
1338-queries-quality-and-percentage
1390-average-selling-price
1415-students-and-examinations
1509-replace-employee-id-with-the-unique-identifier
1724-customer-who-visited-but-did-not-make-any-transactions
1773-percentage-of-users-attended-a-contest
1801-average-time-of-process-per-machine
1827-invalid-tweets
1908-recyclable-and-low-fat-products
2087-confirmation-rate
2495-number-of-unique-subjects-taught-by-each-teacher

Array

0041-first-missing-positive
0238-product-of-array-except-self
0870-magic-squares-in-grid
0999-regions-cut-by-slashes
2180-maximum-number-of-tasks-you-can-assign

Hash Table

0041-first-missing-positive
0870-magic-squares-in-grid
0999-regions-cut-by-slashes

Math

0870-magic-squares-in-grid

Matrix

0870-magic-squares-in-grid
0999-regions-cut-by-slashes

Depth-First Search

0999-regions-cut-by-slashes
1382-balance-a-binary-search-tree

Breadth-First Search

0999-regions-cut-by-slashes

Union Find

0999-regions-cut-by-slashes

Binary Search

2180-maximum-number-of-tasks-you-can-assign

Greedy

1382-balance-a-binary-search-tree
2180-maximum-number-of-tasks-you-can-assign

Queue

2180-maximum-number-of-tasks-you-can-assign

Sorting

2180-maximum-number-of-tasks-you-can-assign

Monotonic Queue

2180-maximum-number-of-tasks-you-can-assign

Divide and Conquer

1382-balance-a-binary-search-tree

Tree

1382-balance-a-binary-search-tree

Binary Search Tree

1382-balance-a-binary-search-tree

Binary Tree

1382-balance-a-binary-search-tree

Prefix Sum

0238-product-of-array-except-self