CARVANA Interview Question

Basic SQL questions, aggregations and case statements