Get the top 10 departments overall ranked by total sales normalized by the size of the store where the sales were recorded

I need an SQL query.

The tables are:

• Holidays (WeekDate, IsHoliday)
• Stores (Store, Type, Size)
• TemporalData (Store, WeekDate, Temperature, FuelPrice, CPI, UnemploymentRate)
• Sales (Store, Dept, WeekDate, WeeklySales)