Pregunta de entrevista de CARVANA

Basic SQL questions, aggregations and case statements