SQL

텍스트

Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA.The CITY table

출처: HackerRank: Advanced SelectMYSQL 사용Write a query identifying the type of each record in the TRIANGLES table using its three side lengths. Output o

글 속에 이미지가 있어서 복사가 잘 안된다ㅠWrite a query that prints a list of employee names (i.e.: the name attribute) for employees in Employee having a salary greate

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 q

A median is defined as a number separating the higher half of a data set from the lower half. Query the median of the Northern Latitudes (LAT_N) from

나의 풀이

지역별 주문의 특징난이도3https://solvesql.com/problems/characteristics-of-orders/문제에서 'region, category 별 주문량을 계산'을 요구했기에 각 행이 하나의 주문으로 생각했는데, 실패.다른 풀이를 검색해

EasyWrite a solution to report all the duplicate emails. Note that it's guaranteed that the email field is not NULL.\+-------------+---------+| Column