Write a query to find the second-highest revenue-generating property in each market using a window function.
You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.