Geotab interview question

A few sql problems in leetcode style