Clean Harbors interview question

They asked me for the syntax in SQL