DataLemur, free tier, MEDIUM Nothing special here again, use can use CTE or a subselect, the main target of this question was to get you to use RANK() or ROW_NUMBER() WINDOW FUNCTION.  

DataLemur, free tier This goes over the basics pretty much. use of aggregates use of HAVING use of multiple order by conditions use of limit; Not tricky