Foot Locker Interview Question

Write a specific SQL query in one line.