oj-sql

SQL online judge exercise.

Pages available at redolog.github.io/oj-sql/.

wiki

• MySQL窗口函数
• CTE with语句
• all 子查询语句
• CaseWhen 条件语句
• COALESCE 函数
• GROUP_CONCAT 函数

list of solutions

leetcode

• 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

codility

• EventsDelta

nowcoder牛客

• 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