Sigma Computing interview question

Live SQL coding and the edge cases