ICF interview question

Small SQL challenge with selecting, limiting, and joining and group by