Yardi Systems Interview Question

SQL questions with the ORDER BY, HAVING and COUNT clauses/functions