AT&T interview question

Write SQL query to get information from table