Cosuno Ventures interview question

There was an SQL question around selecting from a table but filter based upon data in the same column