Skillizen interview question

what is join ,how to fetch data through particular name,what is sorting