전체 글51 저자 별 카테고리 별 매출액 집계하기 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 2023. 2. 9. 서울에 위치한 식당 목록 출력하기 - 프로그래머스 문제 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 2023. 2. 8. 904. Fruit Into Baskets 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.. 2023. 2. 7. 1091. Shortest Path in Binary Matrix 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-.. 2023. 2. 6. 2091. Removing Minimum and Maximum From Array 2091. Removing Minimum and Maximum From Array Medium You are given a 0-indexed array of distinct integers nums. There is an element in nums that has the lowest value and an element that has the highest value. We call them the minimum and maximum respectively. Your goal is to remove both these elements from the array. A deletion is defined as either removing an element from the front of the array.. 2023. 2. 1. Pomodoro - TS, React, Tailwind CSS 이번에 frontend mento 사이트에서 간단한 타이머를 만들어 봤습니다. 사용한 기술 스택 typescript react tailwind css headlessui react-countdown-circle-timer 구현 사항 1. 반응형 (모바일, 태블릿, pc) 2. 타이머 3. 환경 설정 모달 4. 시간, 폰트, 색깔 설정 1. 반응형 구현 tailwind css를 사용하면 반응형 디자인을 쉽게 구현할 수 있기 때문에 tailwind css를 사용했습니다. 필요한 색깔, 폰트, 사이즈 등을 tailwind.config에 세팅해 줍니다. 2. 타이머 구현 타이머 구현은 react-countdown-circle-timer 라이브러리를 사용해서 구현하였습니다. 3. 환경 설정 모달 및 홈 화면 탭바.. 2023. 1. 2. 이전 1 2 3 4 5 ··· 9 다음
