Gap Inc. Interview Question

Recruiter interview on the first call which is unexpected. Simple sql query on the formal interview.