P.I. Works interview question

Basic SQL question about DDL, DML.