SQL online judge exercise.
Pages available at redolog.github.io/oj-sql/.
- 175_CombineTwoTables
- 176_SecondHighestSalary
- 177_NthHighestSalary
- 178_RankScores
- 181_EmployeesEarningMoreThanTheirManagers
- 182_DuplicateEmails
- 183_CustomersWhoNeverOrder
- 184_DepartmentHighestSalary
- 185_DepartmentTopThreeSalaries
- 186_DeleteDuplicateEmails
- 197_RisingTemperature
- 262_TripsAndUsers
- 511_GamePlayAnalysisI
- 584_FindCustomerReferee
- 586_CustomerPlacingLargestNumberOfOrders
- 595_BigCountries
- 596_ClassesMoreThan5Students
- 601_HumanTrafficOfStadium
- 608_SalesPerson
- 608_TreeNode
- 620_NotBoringMovies
- 626_ExchangeSeats
- 627_SwapSalary
- 1050_ActorsAndDirectorsWhoCooperatedAtLeastThreeTimes
- 1084_SalesAnalysisIII
- 1141_UserActivityForThePast30DaysI
- 1148_ArticleViewsI
- 1158_MarketAnalysisI
- 1179_ReformatDepartmentTable
- 1393_CapitalGainLoss
- 1407_TopTravellers
- 1484_GroupSoldProductsByTheDate
- 1527_PatientsWithACondition
- 1581_CustomersWhoVisitedButDidNotMakeAnyTransactions
- 1587_BankAccountSummaryII
- 1667_FixNamesInATable
- 1693_DailyLeadsAndPartners
- 1729_FindFollowersCount
- 1741_FindTotalTimeSpentByEachEmployee
- 1795_RearrangeProductsTable
- 1873_CalculateSpecialBonus
- 1890_LatestLoginIn2020
- 1965_EmployeesWithMissingInformation
- 110_Insert
- 111_Insert
- 112_Insert
- 113_Update
- 114_Update
- 115_Delete
- 116_Delete
- 117_Truncate
- 118_CreateTableIfNotExist
- 119_AlterTable
- 120_DropTable
- 121_CreateIndex
- 122_DropIndex
- 123_TruncatedAvgScoreOfHardSql
- 124_ReportExamCount
- 125_ScoreGreaterThanOrEqualToAvg
- 126_AvgActiveDaysAndMAU
- 127_MonthCntAndAvgDayCnt
- 128_IncompleteCntGreaterThan1AndValidUser
- 129_MonthlyAvgSubmitCntGreaterThan3UserRelatedTags
- 130_ExamUVAndAvgScore
- 131_ScoreGreaterThan80LevelDistribution
- 132_ExamQuestionUvPv
- 133_AwardTopStudentsInTwoActivities
- 134_StatValidExamAndQuestionCnt