How would you use SQL to identify the top 10 stores by year-over-year sales growth, including ties and ranking logic?
