P.I. Works Interview Question

Basic SQL question about DDL, DML.