Stanford University Interview Question

SQL-based questions related to joins and window functions.