DoorDash interview question

Making advanced SQL queries with subqueries and using the correct flavor of SQL they use