🛠️Skill/CodingTest29 [leetcode] 550. Game Play Analysis IV/ 이틀 연속 로그인한 유저 /LEFT JOIN/IN 550. Game Play Analysis IV https://leetcode.com/problems/game-play-analysis-iv/ Game Play Analysis IV - LeetCode Can you solve this real interview question? Game Play Analysis IV - Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com Write an SQL query to report the fraction of players that logg.. 2023. 2. 19. [leetcode] 1164. Product Price at a Given Date / 지정 날짜에 변경된 데이터 조회 / UNION 1164. Product Price at a Given Date https://leetcode.com/problems/product-price-at-a-given-date/ Product Price at a Given Date - LeetCode Can you solve this real interview question? Product Price at a Given Date - Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com Write an SQL query to find th.. 2023. 2. 17. [leetcode] 577. Employee Bonus / COALESCE 577. Employee Bonus https://leetcode.com/problems/employee-bonus/ Employee Bonus - LeetCode Can you solve this real interview question? Employee Bonus - Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com Write an SQL query to report the name and bonus amount of each employee with a bonus less .. 2023. 1. 15. [leetcode] 1158. Market Analysis I / CASE WHEN, IFNULL 1158. Market Analysis I https://leetcode.com/problems/market-analysis-i/ Market Analysis I - LeetCode Can you solve this real interview question? Market Analysis I - Table: Users +----------------+---------+ | Column Name | Type | +----------------+---------+ | user_id | int | | join_date | date | | favorite_brand | varchar | +----------------+---------+ u leetcode.com Write an SQL query to find.. 2022. 12. 30. [프로그래머스] Lv4. 저자 별 카테고리 별 매출액 집계하기 https://school.programmers.co.kr/learn/courses/30/lessons/144856 프로그래머스 코드 중심의 개발자 채용. 스택 기반의 포지션 매칭. 프로그래머스의 개발자 맞춤형 프로필을 등록하고, 나와 기술 궁합이 잘 맞는 기업들을 매칭 받으세요. programmers.co.kr 문제 정답코드 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 sales_date LIKE '202.. 2022. 12. 18. [프로그래머스] Lv2.조건에 맞는 도서와 저자 리스트 출력/Lv3. 카테고리 별 도서 판매량 집계 Lv2.조건에 맞는 도서와 저자 리스트 출력하기 / JOIN https://school.programmers.co.kr/learn/courses/30/lessons/144854 프로그래머스 코드 중심의 개발자 채용. 스택 기반의 포지션 매칭. 프로그래머스의 개발자 맞춤형 프로필을 등록하고, 나와 기술 궁합이 잘 맞는 기업들을 매칭 받으세요. programmers.co.kr 정답코드 SELECT book_id, author_name, DATE_FORMAT(published_date, '%Y-%m-%d') PUBLISHED_DATE FROM book B JOIN author A ON B.author_id = A.author_id WHERE B.category = '경제' ORDER BY published_d.. 2022. 12. 16. 이전 1 2 3 4 5 다음
