AT&T Interview Question

Some basic SQL questions - write a query