본문 바로가기

전체 글206

[SQL] 해커랭크 Occupations SELECT MAX(CASE WHEN A.OCCUPATION = 'Doctor' THEN NAME END) AS 'Doctor' , MAX(CASE WHEN A.OCCUPATION = 'Professor' THEN NAME END) AS 'Professor' , MAX(CASE WHEN A.OCCUPATION = 'Singer' THEN NAME END) AS 'Singer' , MAX(CASE WHEN A.OCCUPATION = 'Actor' THEN NAME END) AS 'Actor' FROM ( SELECT NAME , OCCUPATION , ROW_NUMBER() OVER (PARTITION BY OCCUPATION ORDER BY NAME) AS RN FROM OCCUPATIONS ) A GR.. 2022. 12. 3.
[SQL] 해커랭크 The PADS SELECT CONCAT(NAME, '(', SUBSTR(OCCUPATION, 1, 1), ')') FROM OCCUPATIONS ORDER BY NAME; SELECT CONCAT('There are a total of ', COUNT(OCCUPATION), ' ', LOWER(OCCUPATION), 's.') FROM OCCUPATIONS GROUP BY OCCUPATION ORDER BY COUNT(OCCUPATION), OCCUPATION 해커랭크 The PADS SQL 2022. 12. 2.
[SQL] 해커랭크 Type of Triangle SELECT CASE WHEN A = B AND B = C THEN 'Equilateral' WHEN A + B 2022. 12. 2.
[SQL] 해커랭크 Weather Observation Station 6~7 SELECT DISTINCT CITY FROM STATION WHERE (CITY LIKE 'a%' OR CITY LIKE 'e%' OR CITY LIKE 'i%' OR CITY LIKE 'o%' OR CITY LIKE 'u%') a로 시작하는 문자열을 검색 : 'a%' a로 시작하는 3글자의 문자열 검색 : 'a__' SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[aeiou]' 정규 표현식 REGEXP : LIKE보다 복잡한 문자열 조건으로 검색 가능 ^[aeiou] : a 또는 e 또는 i 또는 o 또는 u로 시작하는 문자열 SELECT DISTINCT CITY FROM STATION WHERE (CITY LIKE '%a' OR CITY LIKE '.. 2022. 12. 2.
[SQL] 해커랭크 Weather Observation Station 5 (SELECT CITY, LENGTH(CITY) FROM STATION WHERE LENGTH(CITY) = (SELECT MIN(LENGTH(CITY)) FROM STATION) ORDER BY CITY LIMIT 1) UNION ALL (SELECT CITY, LENGTH(CITY) FROM STATION WHERE LENGTH(CITY) = (SELECT MAX(LENGTH(CITY)) FROM STATION) ORDER BY CITY LIMIT 1) (SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) ASC, CITY ASC LIMIT 1); (SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGT.. 2022. 12. 2.
[SQL] 프로그래머스 [Level-4] 그룹별 조건에 맞는 식당 목록 출력하기 SELECT A.MEMBER_NAME , B.REVIEW_TEXT , DATE_FORMAT(B.REVIEW_DATE, '%Y-%m-%d') AS REVIEW_DATE FROM MEMBER_PROFILE A , REST_REVIEW B WHERE A.MEMBER_ID = B.MEMBER_ID AND B.MEMBER_ID IN ( SELECT MEMBER_ID FROM REST_REVIEW GROUP BY MEMBER_ID HAVING COUNT(MEMBER_ID) = ( SELECT COUNT(MEMBER_ID) AS CNT FROM REST_REVIEW GROUP BY MEMBER_ID ORDER BY COUNT(MEMBER_ID) DESC LIMIT 1 ) ) ORDER BY B.REVIEW_DATE,.. 2022. 12. 2.

티스토리툴바