본문 바로가기

전체 글625

[파이썬, 자바] 백준 1012 : 유기농 배추 (실버2) [파이썬, 자바] 백준 1012 : 유기농 배추 (실버2)https://www.acmicpc.net/problem/1012풀이방향성 생각배추 찾으면 BFS 돌리기BFS 돌린 횟수 카운팅해서 출력하기. 파이썬from collections import dequeimport sysinput = lambda : sys.stdin.readline().rstrip()inside = lambda x,y : 0테케 받아서 BFS 돌리기자바import java.io.*;import java.util.*;public class Main { public static int T, H, W, K; public static int[][] dire = {{1, 0}, {0, 1}, {-1, 0}, {0, -1}}; .. 2025. 1. 31.
leetcode : 1393. Capital Gain/Loss leetcode : 1393. Capital Gain/Loss[leetcode : 1393. Capital Gain/Loss]다이어그램erDiagram STOCK_OPERATIONS { string stock_name string operation int operation_day int price }각 주식별 총 gain loss 구하기문제 풀이MySQL 1select stock_name, sum(if(operation='buy', -price, price)) as capital_gain_lossfrom stocksgroup by stock_name처음에는 group by로 주식별 buy sell 나누려고 했다.이러면 두 테이블 join시 nu.. 2025. 1. 31.
leetcode : 1378. Replace Employee ID With The Unique Identifier leetcode : 1378. Replace Employee ID With The Unique Identifier[leetcode : 1378. Replace Employee ID With The Unique Identifier]다이어그램erDiagram TABLE { int id varchar name }목표각 유저의 id가 unique인지 판별하고 unique하면 id를, 아니면 null을 반환하는 문제문제 풀이MySQLselect u.unique_id, e.namefrom employees eleft join employeeUNI u on e.id = u.id;기본 left join 문제이다.행 수가 더 많은 emp테이블을 기준으로 emp uni와 left joi.. 2025. 1. 31.
leetcode : 1341. Movie Rating leetcode : 1341. Movie Ratinghttps://leetcode.com/problems/movie-rating/description/다이어그램erDiagram Movies { int movie_id PK varchar title } Users { int user_id PK varchar name UK } MovieRating { int movie_id PK int user_id PK int rating date created_at } MovieRating }|--|| Movies : "movie_id" MovieRating }|--|| Users.. 2025. 1. 26.

티스토리툴바