Treasure Data interview question

SQL questions - outer/inner joins,