UPMC interview question

-Basic SQL commands and tables related questions anyone would know