Hackerrank19 [MYSQL] Hackerrank - Binary Tree Nodes https://www.hackerrank.com/challenges/binary-search-tree-1/problem?isFullScreen=true Binary Tree Nodes | HackerRank Write a query to find the node type of BST ordered by the value of the node. www.hackerrank.com 문제 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 Bi.. 2023. 1. 4. [MYSQL] Hackerrank - The PADS https://www.hackerrank.com/challenges/the-pads/problem?isFullScreen=true The PADS | HackerRank Query the name and abbreviated occupation for each person in OCCUPATIONS. www.hackerrank.com 문제 Generate the following two result sets: Query an alphabetically ordered list of all names in OCCUPATIONS, immediately followed by the first letter of each profession as a parenthetical (i.e.: enclosed in par.. 2022. 12. 22. [MYSQL] Hackerrank - Employee Salaries https://www.hackerrank.com/challenges/salary-of-employees/problem Employee Salaries | HackerRank Print the names of employees who earn more than $2000 per month and have worked at the company for less than 10 months. www.hackerrank.com 문제 Write a query that prints a list of employee names (i.e.: the name attribute) for employees in Employee having a salary greater than 2000$ per month who have b.. 2022. 12. 16. [MYSQL] Hackerrank - Employee Names https://www.hackerrank.com/challenges/name-of-employees/problem Employee Names | HackerRank Print employee names. www.hackerrank.com 문제 Write a query that prints a list of employee names (i.e.: the name attribute) from the Employee table in alphabetical order. Input Format The Employee table containing employee data for a company is described as follows: where employee_id is an employee's ID num.. 2022. 12. 16. 이전 1 2 3 4 5 다음