GBG interview question

How to write a sql join statement