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

Would you like to read more?