일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 |
- LV. 2
- engines locking
- Vite
- Medium
- 호이스팅
- medinum
- React Public Routes
- toast-ui-editor
- Biweekly Contest 79
- sql
- 모던 자바스크립티 Deep Dive
- React Private Routes
- .env
- React.memo
- BFS
- 모던 자바스크립트 Deep Dive
- eslintrc
- leetcode
- next.js
- React
- javascript
- commitlint
- tailwindcss
- Weekly Contest
- next-auth
- React Router dom v6
- react-dom
- 프로그래머스
- 컴포넌트 최적화
- Sanity.io
- Today
- Total
목록전체 글 (55)
뚜벅
1162. As Far from Land as Possible Medium Given an n x n grid containing only values 0 and 1, where 0 represents water and 1 represents land, find a water cell such that its distance to the nearest land cell is maximized, and return the distance. If no land or water exists in the grid, return -1. The distance used in this problem is the Manhattan distance: the distance between two cells (x0, y0)..
2306. Naming a Company Hard You are given an array of strings ideas that represents a list of names to be used in the process of naming a company. The process of naming a company is as follows: Choose 2 distinct names from ideas, call them ideaA and ideaB. Swap the first letters of ideaA and ideaB with each other. If both of the new names are not found in the original ideas, then the name ideaA ..
BOOK, AUTHOR, BOOK_SALES 테이블들을 JOIN 하여 판매날짜가 2022년 1월일 때의 데이터를 구하면 됩니다! -- 코드를 입력하세요 SELECT A.AUTHOR_ID, A.AUTHOR_NAME, B.CATEGORY, SUM(BS.SALES * B.PRICE) AS TOTAL_SALES FROM BOOK B JOIN AUTHOR A ON B.AUTHOR_ID = A.AUTHOR_ID JOIN BOOK_SALES BS ON B.BOOK_ID = BS.BOOK_ID WHERE DATE_FORMAT(BS.SALES_DATE, '%Y%m') LIKE '202201' GROUP BY B.AUTHOR_ID, B.CATEGORY ORDER BY B.AUTHOR_ID, B.CATEGORY DESC
문제 REST_INFO, REST_REVIEW 테이블을 JOIN 하여 풀면 되는 문제입니다. 주의할 점은... 서울!! 서울에 위치한 식당들만 찾습니다. 처음에 이거 때문에 계속 해멧네요 ㅜㅜ -- 코드를 입력하세요 SELECT A.REST_ID, A.REST_NAME, A.FOOD_TYPE, A.FAVORITES, A.ADDRESS, ROUND(AVG(B.REVIEW_SCORE),2) AS SCORE FROM REST_INFO AS A JOIN REST_REVIEW AS B ON A.REST_ID = B.REST_ID GROUP BY A.REST_ID HAVING A.ADDRESS LIKE '서울%' ORDER BY AVG(B.REVIEW_SCORE) DESC, A.FAVORITES DESC
904. Fruit Into Baskets Medium You are visiting a farm that has a single row of fruit trees arranged from left to right. The trees are represented by an integer array fruits where fruits[i] is the type of fruit the ith tree produces. You want to collect as much fruit as possible. However, the owner has some strict rules that you must follow: You only have two baskets, and each basket can only ho..
1091. Shortest Path in Binary Matrix Medium Given an n x n binary matrix grid, return the length of the shortest clear path in the matrix. If there is no clear path, return -1. A clear path in a binary matrix is a path from the top-left cell (i.e., (0, 0)) to the bottom-right cell (i.e., (n - 1, n - 1)) such that: All the visited cells of the path are 0. All the adjacent cells of the path are 8-..