Discover Interview Question

using or without using window function to solve sql questions