Lutron Electronics interview question

Sql project and logical question