Shopee interview question

Function of different SQL Joins