Clean Harbors Interview Question

They asked me for the syntax in SQL