Urban Science interview question

SQL queries, left join - right join, optimization, Object oriented programming, current work projects and ect...