CARVANA interview question

Basic SQL questions, aggregations and case statements