Synergy Shipping interview question

how to write a basic sql query to derieve data from table