SQL Join with sum and group by

Web DevelopmentWed May 03 2023

Source: SQL Join with sum and group by

Firstly, your design would work better if it was properly normalised - your Staff table should have a single column representing the Lot that's used by each staff member (if you had 100 lots, would you have 100 columns?). Then there would be no need to pivot the data from columns into the rows you need.

---