Revature interview question

Oops, sql, pseudocodes and sql commands