WinWire Technologies interview question

To write a sql query using join