leetcode

Leetcode_SQL 50 문제 출처 https://leetcode.com/studyplan/top-sql-50/ 1. 문제 "Find Customer Referee" / 환자 상태 Table :Customer Coulumn Name Type id int name varchar referee_id int input ► output id name referee_id name 1 Will null Will 2 Jane null Jane 3 Alex 2 Bill 4 Bill null Zack 5 Zack 1 6 Mark 2 CheckPoint 1. referee_id가 2가 아닌 회원들만 조회 2. 문제 풀이 1차시. 정답 1. referee_id = null or referee_id != 2 SELECT ..

Leetcode_30 Days of Pandas 문제 출처 https://leetcode.com/studyplan/30-days-of-pandas/ 1. 문제 "Patients With a Condition" / 환자 상태 Table :Patients Coulumn Name Type patient_id int patient_name varchar conditions varchar Write a solution to find the patient_id, patient_name, and conditions of the patients who have Type I Diabetes. Type I Diabetes always starts with DIAB1 prefix. Return the result table..

Leetcode_30 Days of Pandas 문제 출처 https://leetcode.com/studyplan/30-days-of-pandas/ 1. 문제 "Find Users With Valid E-Mails" / 유효한 이메일을 가진 사용자 찾기 Table : Users Coulumn Name Type user_id int name varchar mail varchar Write a solution to find the users who have valid emails. A valid e-mail has a prefix name and a domain where: • The prefix name is a string that may contain letters (upper or lower case..

Leetcode_30 Days of Pandas 문제 출처 https://leetcode.com/studyplan/30-days-of-pandas/ 1. 문제 "Fix Names in a Table" / 네임 테이블 수정하기 Table : Users Coulumn Name Type user_id int name varchar Write a solution to fix the names so that only the first character is uppercase and the rest are lowercase. Return the result table ordered by user_id. The result format is in the following example. input ► output u..