X Interview Question

Some basic table manipulation in SQL