Risepoint interview question

They asked a simple SQL question and to explain one of my Python projects.