Calero interview question

SQL queries, triggers and indexes