W3 Engineers interview question

Write an SQL query to select items from table, join table etc.