Wayfair Interview Question

few simple string/list manipulation problems and sql joins/count problems