SQL/SQL 문제풀이 (4) 썸네일형 리스트형 [SQL-P] 해커랭크 Advanced Join_Interviews Advanced Join_Interviews 해결해야할 문제 Q 왜 Colleges 테이블을 조인하는지 Q 왜 View_Stats, Submission_Stats는 INNER JOIN이 아니라 LEFT JOIN 사용하는지 Q WHERE 필터링? HAVING 필터링? Q GROUP BY는 왜 사용하는지 > 집계함수를 썼으니까.. Interviews Discussions | SQL | HackerRank Discussion on Interviews Challenge find total number of view, total number of unique views, total number of submissions and total number of accepted submissions. www.hacker.. [SQL-P] 해커랭크 Advanced Join_Placements Advanced Join_Placements ▲ 첫번째 쿼리문 (오답) Line9 : ON f.Friend_ID = p.ID (f.Friend_ID를 잡은 것은 잘했음!!) Line11: ORDER BY p.Salary; [SQL-P] 해커랭크 Basic Join_African Cities African Cities ** 'AS' (alias)를 쓰는 습관 ** 별칭 뒤에는 무엇을 말하고자하는지 정확하게 써주기 ** ; 붙이는 습관 ** INNER JOIN 구글 인터뷰 질문 SELECT cs.case_id, cs.timestamp, cs.score FROM `untechbox-sql.interview_question.case_score` AS cs INNER JOIN ( SELECT case_id, MAX(timestamp) AS most_recent_date FROM `untechbox-sql.interview_question.case_score` GROUP BY 1 ) AS md ON cs.timestamp = md.most_recent_date AND cs.case_id = md.case_id; Q2. We have a "HISTORY" table with 4 fields User_id Action_date Action_time ActionQ: Create the fo.. 이전 1 다음
