HackerRank / Advanced Join / SQL Project Planning / MySQL
2024. 1. 17. 15:28
📚문제 https://www.hackerrank.com/challenges/sql-projects/problem?isFullScreen=true SQL Project Planning | HackerRank Write a query to output the start and end dates of projects listed by the number of days it took to complete the project in ascending order. www.hackerrank.com 문제 내용이 길어서 링크로 첨부 📝풀이 SELECT Start_Date , MIN(End_Date) FROM ((SELECT Start_Date FROM Projects WHERE Start_Date NOT IN (SEL..
