'코딩연습이 좋아서/SQL이 좋아서' 카테고리의 글 목록 (8 Page)

가장 비싼 상품 구하기

2025.02.01

SELECT MAX(PRICE) AS MAX_PRICEFROM PRODUCT;

2025.01.31

SELECT ID,LENGTHFROM FISH_INFO WHERE LENGTH IS NOT NULLORDER BY LENGTH DESC, ID LIMIT 10;

2025.01.31

SELECT COUNT(*) AS FISH_COUNTFROM FISH_INFO WHERE LENGTH IS NULL;

2025.01.31

SELECT ID, EMAIL, FIRST_NAME, LAST_NAMEFROM DEVELOPER_INFOS WHERE SKILL_1 = "Python"|| SKILL_2 = "Python" || SKILL_3 = "Python"ORDER BY ID;

2025.01.31

SELECT COUNT(*) AS USERSFROM USER_INFO WHERE AGE >=20 AND AGE

2025.01.31

SELECT NAMEFROM ANIMAL_INS ORDER BY DATETIME LIMIT 1;

2025.01.31

SELECT ANIMAL_ID, NAME, DATETIMEFROM ANIMAL_INS ORDER BY NAME, DATETIME DESC;

2025.01.31

SELECT ANIMAL_ID, NAMEFROM ANIMAL_INS ORDER BY ANIMAL_ID;

2025.01.31

SELECT ANIMAL_ID, NAMEFROM ANIMAL_INS WHERE INTAKE_CONDITION != "Aged"ORDER BY ANIMAL_ID;

2025.01.31

SELECT ANIMAL_ID, NAMEFROM ANIMAL_INSWHERE INTAKE_CONDITION = "sick";