How to display the presence and absence of nth-highest group-wise values in SQL A step-by-step breakdown of the query.