SQL 공부
1.[HackerRank] Type of Triangle연습문제
HACKERRANK Type of Triangle 연습문제문제: Write a query identifying the type of each record in the TRIANGLES table using its three side lengths. Output one
2.[LeetCode 연습문제] Reformat Department Table
Reformat Department Table\+-------------+---------+| Column Name | Type |\+-------------+---------+| id | int || revenue | int
3.[Haker Rank] African Cities
Given the CITY and COUNTRY tables, query the names of all cities where the CONTINENT is 'Africa'.Note: CITY.CountryCode and COUNTRY.Code are matching
4.[Hacker Rank]Average Population of Each Continent
Given the CITY and COUNTRY tables, query the names of all the continents (COUNTRY.Continent) and their respective average city populations (CITY.Popul
5.[Leet Code] Customers Who Never Order
\+-------------+---------+| Column Name | Type |\+-------------+---------+| id | int || name | varchar |\+-------------+-------
6.[Leet Code] Employees Earning More Than Their Managers
\+-------------+---------+| Column Name | Type |\+-------------+---------+| id | int || name | varchar || salary | int
7.[Leet Code]Rising Temperature
Table: Weather\+---------------+---------+| Column Name | Type |\+---------------+---------+| id | int || recordDate | date
8.[Haker Rank]Symmetric Pairs
You are given a table, Functions, containing two columns: X and Y.Two pairs (X1, Y1) and (X2, Y2) are said to be symmetric pairs if X1 = Y2 and X2 = Y