날아보자!

Weather Observation Station 2 Query the following two values from the STATION table: The sum of all values in LAT_N rounded to a scale of 2 decimal places. The sum of all values in LONG_W rounded to a scale of 2 decimal places.Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. Output Format Your results must be in the..

Revising Aggregations - The Count Function Query a count of the number of cities in CITY having a Population larger than 100,000. Input Format SELECT COUNT(*) FROM CITY WHERE POPULATION > 100000; Revising Aggregations - The Sum Function Query the total population of all cities in CITY where District is California. Input Format SELECT SUM(POPULATION) FROM CITY WHERE DISTRICT = 'California'; Revis..

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..