목록분류 전체보기 (177)
홍동이의 성장일기
[LeetCode] 570. Managers with at Least 5 Direct Reports
Managers with at Least 5 Direct Reports - LeetCode Can you solve this real interview question? Managers with at Least 5 Direct Reports - Table: Employee +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | department | varchar | | managerId | int | +- leetcode.com SELECT m.name as name FROM employee e INNER JOIN employee m ON e.managerId = ..
[LeetCode] 550. Game Play Analysis IV
Game Play Analysis IV - LeetCode Can you solve this real interview question? Game Play Analysis IV - Table: Activity +--------------+---------+ | Column Name | Type | +--------------+---------+ | player_id | int | | device_id | int | | event_date | date | | games_played | int | +--------- leetcode.com WITH cte_login AS( SELECT player_id , DATEDIFF(event_date, MIN(event_date) OVER(PARTITION BY pl..
[LeetCode] 262. Trips and Users
Trips and Users - LeetCode Can you solve this real interview question? Trips and Users - Table: Trips +-------------+----------+ | Column Name | Type | +-------------+----------+ | id | int | | client_id | int | | driver_id | int | | city_id | int | | status | enum | | request_at | leetcode.com 취소율은 금지되지 않은 사용자가 있는 취소된(클라이언트별 또는 드라이버별) 요청의 수를 해당일의 금지되지 않은 사용자가 있는 요청의 총 수로 나누어 계산됩니다. "2013-10-01"..
보호되어 있는 글입니다.
[LeetCode] 184. Department Highest Salary
Department Highest Salary - LeetCode Can you solve this real interview question? Department Highest Salary - Table: Employee +--------------+---------+ | Column Name | Type | +--------------+---------+ | id | int | | name | varchar | | salary | int | | departmentId | int | +--------------+--- leetcode.com [풀이 1] 다중컬럼 서브쿼리 select d.name Department , e.name Employee , e.salary Salary from employee..
[LeetCode] 181. Employees Earning More Than Their Managers
Employees Earning More Than Their Managers - LeetCode Can you solve this real interview question? Employees Earning More Than Their Managers - Table: Employee +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | salary | int | | managerId | int | +------ leetcode.com Write an SQL query to find the employees who earn more than their managers..
[LeetCode] 183. Customers Who Never Order
Customers Who Never Order - LeetCode Can you solve this real interview question? Customers Who Never Order - Table: Customers +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | +-------------+---------+ In SQL, id is the primary key colu leetcode.com Write a solution to find all customers who never order anything. Return the result table in..
[LeetCode] 1179. Reformat Department Table
Reformat Department Table - LeetCode Can you solve this real interview question? Reformat Department Table - Table: Department +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | revenue | int | | month | varchar | +-------------+---------+ (id, month) is leetcode.com Reformat the table such that there is a department id column and a revenue column for each ..
보호되어 있는 글입니다.
컴활 1급 & 2급 독학 합격 후기 (+ 시험정보, 공부법, TIP)
안녕하세요 👋 오늘은 2020년 취득한 컴활2급과 2022년에 취득한 컴활1급 합격 후기에 대해 이야기해보겠습니다. 1. 컴활 2급 공부법 2. 컴활 1급 공부법 1급과 2급 모두 취득한 이유 대학생에게 필수라는 컴활! 2급은 취득하기 쉽다는 이야기를 듣고 2학년이 끝나는 방학을 이용하여 자격증을 땄습니다. 나중에 과동기랑 이야기하다 알게된 사실,, 3학년부터 본격적으로 복수전공을 했던 경영학과 졸업요건에 컴활 1급이 있다는 것😑 대학생 여러분,, 자격증 따기 전에 꼭 주전공, 복수전공 졸업요건을 확인하세요 ㅎ 컴활 2급 정보 시험방법 시험과목 출제형태 시험시간 필기시험 컴퓨터 일반 스프레드시트 일반 객관식 40문항 40분 실기시험 스프레드시트 실무 컴퓨터 작업형 40분 합격결정기준 - 필기: 과목당 4..