This question was awkward for me to answer. I have a feeling the interviewer may have wanted me to go beyond SQL to accomplish this but we didn't have enough time to work through it.