HackerRank SQL 刷题总结 的SQL难度总体比leetcode要低太多了,但如果要让我形容一下力扣的database题目,那就是“上锁的房间“。在正式买leetcode会员之前,看到这个免费的刷题平台,我认为还是很适合入门的。 但这个平台有一些我个人不是特别喜欢的地方:一是界面设计对写代码不太友好,它的代码窗口在页面最下方,对于...
Advanced Select Binary Tree Nodes 30 Medium Solution.sql Advanced Select New Companies 30 Medium Solution.sql Aggregation Revising Aggregations - The Count Function 10 Easy Solution.sql Aggregation Revising Aggregations - The Sum Function 10 Easy Solution.sql Aggregation Revising Aggregations - Averages ...
Trees Tree: Level Order Traversal 20 Solution.java Trees Tree: Huffman Decoding 20 Solution.java Trees Binary Search Tree: Insertion 20 Solution.java Trees Binary Search Tree: Lowest Common Ancestor 30 Solution.java Trees Is This a Binary Search Tree? 30 Solution.java Trees Swap Nodes [Algo] ...
Trees Tree: Level Order Traversal 20 Solution.java Trees Tree: Huffman Decoding 20 Solution.java Trees Binary Search Tree: Insertion 20 Solution.java Trees Binary Search Tree: Lowest Common Ancestor 30 Solution.java Trees Is This a Binary Search Tree? 30 Solution.java Trees Swap Nodes [Algo] ...
3.Binary Tree Nodes image.png image.png image.png selectN,casewhenPisNULLthen'Root'whenNin(selectPfromBST)then'Inner'else'Leaf'endasNodefromBSTorder by N; SELECTN,IF(PISNULL,'Root',IF((SELECTCOUNT(*)FROMBSTWHEREP=B.N)>0,'Inner','Leaf'))FROMBSTASBORDERBYN; ...
24Binary Tree NodesSolutionMediumAdvanced Select 25New CompaniesSolutionMediumAdvanced Select 26Revising Aggregations - The Count FunctionSolutionEasyAggregation 27Revising Aggregations - The Sum FunctionSolutionEasyAggregation 28Revising Aggregations - The Average FunctionSolutionEasyAggregation ...
Advanced Select Binary Tree Nodes 30 Medium Solution.sql Advanced Select New Companies 30 Medium Solution.sql Aggregation Revising Aggregations - The Count Function 10 Easy Solution.sql Aggregation Revising Aggregations - The Sum Function 10 Easy Solution.sql Aggregation Revising Aggregations - Averages ...
Trees Swap Nodes [Algo] Medium 40 Solution.java Trees Is This a Binary Search Tree? Medium 30 Solution.cpp Balanced Trees Self Balancing Tree Medium 50 Solution.java Stacks Maximum Element Easy 20 Solution.java Stacks Balanced Brackets Medium 25 Solution.java Stacks Equal Stacks Easy 25 Solution...