This advanced SQL exercise is part of the book: Advanced SQL – Practical Techniques and Use-Cases, which includes 100 day-to-day SQL challenges (and solutions), need-to-know advanced features, and key concepts.
Given a table that specifies the profits of a certain chain store, divided by categories and years:
CREATE TABLE revenues ([YearID] int, [Women's Clothing] int, [Men's Clothing] int, [Phones & Telecommunications] int, [Computer & Office] int, [Consumer Electronics] int, [Jewelry & Accessories] int, [Home & Garden] int) GO