🐷전동준(Jeon DongJun)

Go with the flow

[HackerRank(해커랭크)/SQL]내가 푼 MySQL 쿼리 기록 - 1



📌내가 푼 MySQL 쿼리 기록 - 1

Revising the Select Query I

  • 쿼리💻
SELECT * FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION >= 100000;


Revising the Select Query II

  • 쿼리💻
SELECT NAME FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION >= 120000;


Select ALL

  • 쿼리💻
SELECT * FROM CITY;


Select By ID

  • 쿼리💻
SELECT * FROM CITY WHERE ID = 1661;


Japanese Cities’ Attributes

  • 쿼리💻
SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN';


Japanese Cities’ Names

  • 쿼리💻
SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN';


Weather Observation Station 1

  • 쿼리💻
SELECT CITY, STATE FROM STATION;


Weather Observation Station 3

  • 쿼리💻
SELECT DISTINCT(CITY) FROM STATION WHERE MOD(ID, 2) = 0;


Weather Observation Station 4

  • 쿼리💻
SELECT (COUNT(CITY) - COUNT(DISTINCT(CITY))) FROM STATION;


Weather Observation Station 5

  • 쿼리💻
SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC, CITY LIMIT 1;
SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) ASC, CITY LIMIT 1;


Weather Observation Station 6

  • 쿼리💻
SELECT DISTINCT(CITY) FROM STATION WHERE LEFT(CITY, 1) IN ('A','E','I','O','U');


Weather Observation Station 7

  • 쿼리💻
SELECT DISTINCT(CITY) FROM STATION WHERE RIGHT(CITY, 1) IN ('A','E','I','O','U');


Weather Observation Station 8

  • 쿼리💻
SELECT DISTINCT(CITY) FROM STATION WHERE (LEFT(CITY, 1) IN ('A','E','I','O','U')) AND (RIGHT(CITY, 1) IN ('A','E','I','O','U'));


Weather Observation Station 9

  • 쿼리💻
SELECT DISTINCT(CITY) FROM STATION WHERE LEFT(CITY, 1) NOT IN ('A','E','I','O','U');


Weather Observation Station 10

  • 쿼리💻
SELECT DISTINCT(CITY) FROM STATION WHERE RIGHT(CITY, 1) NOT IN ('A','E','I','O','U');


2022

[web]jQuery 복습 3

1 분 소요

[Noitce] 고쳐야하거나 틀린 것이 있으면 말씀해주세요!

[web]jQuery 복습 2

13 분 소요

[Noitce] 고쳐야하거나 틀린 것이 있으면 말씀해주세요!

[web]jQuery 복습 1

14 분 소요

[Noitce] 고쳐야하거나 틀린 것이 있으면 말씀해주세요!

[web]JavaScript 정리4

5 분 소요

[Noitce] 고쳐야하거나 틀린 것이 있으면 말씀해주세요!

[web]JavaScript 정리3

10 분 소요

[Noitce] 고쳐야하거나 틀린 것이 있으면 말씀해주세요!

[web]JavaScript 정리2

7 분 소요

[Noitce] 고쳐야하거나 틀린 것이 있으면 말씀해주세요!

[web]JavaScript 정리1

8 분 소요

[Noitce] 고쳐야하거나 틀린 것이 있으면 말씀해주세요!

[web]CSS 기초 정리

11 분 소요

[Noitce] 고쳐야하거나 틀린 것이 있으면 말씀해주세요!

[web]HTML 기초 정리

8 분 소요

[Noitce] 고쳐야하거나 틀린 것이 있으면 말씀해주세요!

[Pandas]pandas 연습

3 분 소요

[Noitce] 고쳐야하거나 틀린 것이 있으면 말씀해주세요!

맨 위로 이동 ↑

2021

[Python기초]module

1 분 소요

[Noitce] 고쳐야하거나 틀린 것이 있으면 말씀해주세요!

맨 위로 이동 ↑