Yotta Tech Ports interview question

SQL Questions about Aggregate functions and window functions