SQL Count Query with Grouping by multiple Columns
- by Christian
I have a table with three filled columns named "Name", "City" and "Occupation".
I want to create a new column in the same table that contains the number of people who have the same occupation.
"Name" | "City" | "Occupation"
------------------------------
Amy | Berlin | Plumber
Bob | Berlin | Plumber
Carol | Berlin | Lawyer
David | London |…