HSBC interview question

Asked to write simple DDL and DML statements?