Indium Software Interview Question

SQL Joins Aggregates Window function CTE