Ace SQL Interview Questions: Solving the Unique Work Days Problem for Data Scientists

[@iqjayfeng]

Want to ace your data science interview? 🚀 85% of successful candidates practice with real interview questions. Explore the ones companies actually ask: www.interviewquery.com/questions?

[@noxshxeexn]

thank you 🙏🏼

[@melvinsaji2805]

Just a thought would this work Datediff(max_end_date, min_start_date) Min(start_date) over(partition by person_id, project_id order by start_date asc) as min_start_date Max(end_date) over(partition by person_id, project_id order by end_date desc) as max_end_date

[@siddharthpathak2180]

Something like this was my first thought as well. But would this cover the edge case of a person taking time off in the middle of two projects? This would count the off time too right?

[@PratikBorkar1010]

Thank you for sharing this! It was well explained!! 😁

[@iqjayfeng]

Glad you found it insightful!