«   2025/08   »
일 월 화 수 목 금 토
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31
Recent Posts
Link
Today
Total
관리 메뉴

목록Data/SQL (27)

짜리몽땅 매거진

[SQL] 프로그래머스 코딩테스트 연습3

문제1. 과일로 만든 아이스크림 고르기 출처 : 프로그래머스 SQL 고득점 kit - SELECT 문제 정보 : LEVEL 1 / 정답률 81% https://school.programmers.co.kr/learn/courses/30/lessons/133025 정답 쿼리 select a.flavor from first_half a join icecream_info b on a.flavor = b.flavor where total_order > 3000 and ingredient_type = 'fruit_based' order by total_order desc 문제 해설 1. 주요 포인트 1 - where 조건절 where total_order > 3000 and ingredient_type = 'fru..
Data/SQL 2024. 2. 27. 12:50
[SQL] 프로그래머스 코딩테스트 연습2

문제1. 조회수가 가장 많은 중고거래 게시판의 첨부파일 조회하기 출처 : 프로그래머스 SQL 고득점 kit - String, Date 문제 정보 : LEVEL 3 / 정답률 72% https://school.programmers.co.kr/learn/courses/30/lessons/164673https://school.programmers.co.kr/learn/courses/30/lessons/164671 정답 쿼리 SELECT concat("/home/grep/src/",BOARD_ID,"/",FILE_ID,FILE_NAME,FILE_EXT) AS FILE_PATH FROM USED_GOODS_FILE WHERE BOARD_ID = ( SELECT BOARD_ID FROM USED_GOODS_BOAR..
Data/SQL 2024. 2. 19. 23:57
[SQL] 프로그래머스 코딩테스트 연습1

문제1. 조건에 부합하는 중고거래 댓글 조회하기 출처 : 프로그래머스 SQL 고득점 kit - SELECT 문제 정보 : LEVEL 1 / 정답률 61% https://school.programmers.co.kr/learn/courses/30/lessons/164673 정답 쿼리 SELECT TITLE, B.BOARD_ID, REPLY_ID, B.WRITER_ID, B.CONTENTS, DATE_FORMAT(B.CREATED_DATE, '%Y-%m-%d') AS CREATED_DATE FROM USED_GOODS_BOARD AS A JOIN USED_GOODS_BOARD AS B ON A.BOARD_ID = B.BOARD_ID WHERE A.CREATED_DATE BETWEEN '2022-10-01' A..
Data/SQL 2024. 2. 5. 14:39
[SQL] LEFT JOIN, RIGHT JOIN, FULL JOIN, CROSS JOIN, INNER JOIN

DROP DATABASE IF EXISTS pokemon ; CREATE DATABASE pokemon ; USE pokemon ; CREATE TABLE mypokemon ( number INT, name VARCHAR(20), type VARCHAR(10) ); INSERT INTO mypokemon (number, name, type) VALUES (10, 'caterpie', 'bug'), (25, 'pikachu', 'electric'), (26, 'raichu', 'electric'), (133, 'eevee', 'normal'), (152, 'chikoirita', 'grass'); CREATE TABLE ability ( number INT, height FLOAT, weight FLOAT..
Data/SQL 2023. 8. 21. 15:53
[SQL] IF, CASE, 함수 만들기

DROP DATABASE IF EXISTS pokemon; CREATE DATABASE pokemon; USE pokemon; CREATE TABLE mypokemon ( number int, name varchar(20), type varchar(10), attack int, defense int ); INSERT INTO mypokemon (number, name, type, attack, defense) VALUES (10, 'caterpie', 'bug', 30, 35), (25, 'pikachu', 'electric', 55, 40), (26, 'raichu', 'electric', 90, 55), (125, 'electabuzz', 'electric', 83, 57), (133, 'eevee'..
Data/SQL 2023. 8. 16. 17:03
[SQL] GROUP BY, HAVING, 그룹함수

DROP DATABASE IF EXISTS pokemon; CREATE DATABASE pokemon; USE pokemon; CREATE TABLE mypokemon ( number int, name varchar(20), type varchar(10), height float, weight float ); INSERT INTO mypokemon (number, name, type, height, weight) VALUES (10, 'caterpie', 'bug', 0.3, 2.9), (25, 'pikachu', 'electric', 0.4, 6), (26, 'raichu', 'electric', 0.8, 30), (125, 'electabuzz', 'electric', 1.1, 30), (133, '..
Data/SQL 2023. 8. 15. 08:32
[SQL] ORDER BY, 순위함수, 문자형/숫자형/날짜형 함수

DROP DATABASE IF EXISTS pokemon; CREATE DATABASE pokemon; USE pokemon; CREATE TABLE mypokemon ( number INT, name VARCHAR(20), type VARCHAR(10), attack INT, defense INT, capture_date DATE ); INSERT INTO mypokemon (number, name, type, attack, defense, capture_date) VALUES (10, 'caterpie', 'bug', 30, 35, '2019-10-14'), (25, 'pikachu', 'electric', 55, 40, '2018-11-04'), (26, 'raichu', 'electric', 90..
Data/SQL 2023. 8. 14. 18:35
CREATE, INSERT INTO VALUES, SELECT FROM (2)

USE pokemon;SELECT * FROM mypokemon;SELECT type FROM mypokemon WHERE name='eevee'; SELECT attack, defense FROM mypokemonWHERE name='caterpie';SELECT * FROM mypokemonWHERE weight>6 ;SELECT name FROM mypokemonWHERE height>0.5 AND weight>6 ;SELECT name AS weak_pokemon FROM mypokemonWHERE attack=10 or defense-attack>=10 ;SELECT name, attack+defense+speed AS total FROM mypokemonWHERE attack+defense+s..
Data/SQL 2023. 8. 10. 17:07
이전 Prev 1 2 3 4 Next 다음