/DatabasePractice

Database Practice

This repository holds my solutions to MySQL practice problems.

Problems Solved:

  1. Select: LC 180, LC 185, LC 262, LC 595, LC 601, LC 1683
  • Sorting Result Set: LC 586 (Sol 2), LC 620, LC 1459
  1. Joins: LC 178, LC 184, LC 196, LC 550, LC 1126
  • Inner Joins: African Countries (HR)
  • Left Join: LC 571 (Median Given Frequency), LC 580
  • Cross Join/Cartesian Product: LC 1459
  1. Aggregation: Revising Aggregations - The Sum Function (HR), Weather Observation Station 13
  • Group: LC 182, LC 569, LC 571 (Median Given Frequency), LC 580, LC 585, LC 614, LC 1045 (Solution 2), LC 1179, LC 1341, LC 1393
  • Witnessing Problem (Argmax): LC 586 (Sol 1), LC 1077
  1. Delete:
  2. Update: LC 627
  3. Conditional:
  • CASE WHEN THEN ELSE END: LC 569, LC 610, LC 1179, LC 1393
  • IF(): LC 1179
  1. Subqueries: LC 550, LC 585, LC 614, LC 1077, LC 1098, LC 1126, LC 1112, LC 1204
  • NOT IN: LC 1264
  • Subquery in FROM/JOIN: LC 1241
  1. Union, Intersect, Except (All): LC 1212
  • Contains (Not Exists - Except): LC 1045
  1. Ranking:
  • Dense Rank: LC 178