Complex SQL query help on aggregating values for nested subquery
- by François Beausoleil
Hi!
I have people, companies, employees, events and event kinds. I'm making a report/followup sheet where people, companies and employees are the rows, and the columns are event kinds.
Event kinds are simple values describing: "Promised Donation", "Received Donation", "Phoned", "Followed up" and such. Event kinds are ordered:
CREATE TABLE…