AT&T Interview Question

Write SQL query to get information from table