ContentIQ interview question

a SQL ranking question Easy