-
HackerRank Mysql 문제풀이 - Binary Tree Nodes데이터 분석/DB & SQL 2019. 12. 15. 17:47
HackerRank Mysql - Binary Tree Nodes 사전지식. - Sub Query 서브 쿼리 - Control Flow Function 제어문 - NULL 체크 1. 문제 해석 You are given a table, BST, containing two columns: N and P, where N represents the value of a node in Binary Tree, and P is the parent of N. Write a query to find the node type of Binary Tree ordered by the value of the node. Output one of the following for each node: Root: If node is roo..
-
hackerrank mysql Occupations 문제풀이데이터 분석/DB & SQL 2019. 12. 15. 16:11
HackerRank Mysql : Occupations MySQL :: MySQL 8.0 Reference Manual :: 12.4 Control Flow Functions MySQL 8.0 Reference Manual / Functions and Operators / Control Flow Functions 12.4 Control Flow Functions Table 12.6 Flow Control Operators Name Description CASE Case operator IF() If/else construct IFNULL() Null if/else construct NULLIF() Return NULL dev.mysql.com 위 문제는 아래 3 가지를 숙지해야 풀 수 있는 문제이다. 아..