Wayfair Interview Question

SQL question, basic joins from 2 table and ordering