전체 글625 leetcode : 1075. Project Employees I leetcode : 1075. Project Employees I[leetcode : 1075. Project Employees I]다이어그램erDiagram Project { int project_id PK int employee_id FK } Employee { int employee_id PK varchar name int experience_years } Project ||--o{ Employee : "has employees"목표프로젝트 별 평균 근속년수 구하기문제 풀이MySQLSELECT PROJECT_ID, ROUND(AVG(EXPERIENCE_YEARS),2) AS AVERAGE_YEARSFROM ( .. 2025. 1. 13. leetcode : 1070. Product Sales Analysis III leetcode : 1070. Product Sales Analysis III[leetcode : 1070. Product Sales Analysis III]다이어그램erDiagram Sales { int sale_id PK int product_id FK int year int quantity int price } Product { int product_id PK varchar product_name } Sales }o--|| Product : "product_id references product_id"목표각 제품의 첫 정보 불러오기 문제 풀이MySQLSELECT S.PRODUCT_ID,.. 2025. 1. 13. leetcode : 1068. Product Sales Analysis I leetcode : 1068. Product Sales Analysis I[leetcode : 1068. Product Sales Analysis I]다이어그램erDiagram Sales { int sale_id PK int product_id FK int year PK int quantity int price } Product { int product_id PK varchar product_name } Sales }o--|| Product : references목표id별로 이름,년도,가격 구하기문제 풀이MySQL-- Solution 1SELECT P.PRODUCT_NAME, S.YEAR, .. 2025. 1. 12. leetcode : 1050. Actors and Directors Who Cooperated At Least Three Times leetcode : 1050. Actors and Directors Who Cooperated At Least Three Times[leetcode : 1050. Actors and Directors Who Cooperated At Least Three Times]다이어그램erDiagram ActorDirector { int actor_id int director_id int timestamp PK }목표3번 이상 등장한 actor director 쌍 목록 구하기문제 풀이MySQL-- Solution 1SELECT ACTOR_ID, DIRECTOR_IDFROM ( SELECT *, COUNT(*) AS CNT FROM ActorDirector .. 2025. 1. 12. 이전 1 ··· 19 20 21 22 23 24 25 ··· 157 다음
