New Companies Amber's conglomerate corporation just acquired some new companies. Each of the companies follows this hierarchy: Given the table schemas below, write a query to print the company_code, founder name, total number of lead managers, total number of senior managers, total number of managers, and total number of employees. Order your output by ascending company_code. Note: The tables ma..
Binary Tree Nodes 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 root node. Leaf: If node is leaf node. Inner: If node is neither root nor leaf node. Sample I..
Pivot the Occupation column in OCCUPATIONS so that each Name is sorted alphabetically and displayed underneath its corresponding Occupation. The output column headers should be Doctor, Professor, Singer, and Actor, respectively. Note: Print NULL when there are no more names corresponding to an occupation. Input Format The OCCUPATIONS table is described as follows: Occupation will only contain on..
SELECT CONCAT(NAME, '(', LEFT(OCCUPATION,1), ')') FROM OCCUPATIONS ORDER BY NAME; SELECT CONCAT('There are a total of ', COUNT(*), ' ', LOWER(OCCUPATION), 's.') FROM OCCUPATIONS GROUP BY OCCUPATION ORDER BY COUNT(*), OCCUPATION; 11/15일 2차풀이 - 6분
- Total
- Today
- Yesterday
- 미중무역전쟁
- MSSQL
- Tableau
- tensorflow
- 해커랭크
- 넥스트BT
- DATABASE
- python
- TSQL
- insert
- string
- Weather Observation Station
- MS SQL Server
- 대원화성
- python3
- HK이노엔
- hackerrank
- 코로나19
- 경구치료제
- 넷플릭스
- mysql
- 에코캡
- SQL Server
- 테슬라
- 분석탭
- 동국알앤에스
- 몰누피라비르
- list
- 리비안
- 매매일지
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | |
7 | 8 | 9 | 10 | 11 | 12 | 13 |
14 | 15 | 16 | 17 | 18 | 19 | 20 |
21 | 22 | 23 | 24 | 25 | 26 | 27 |
28 | 29 | 30 |