UT Dallas interview question

Basic SQL queries and Excel functions