I have a database structure that has 2 columsn: part and parttype
I want to group the group the query by part types such that i can produce something that looks like
doors, total doors (50)
windows, total doors (3)
How do I do this?
I can do parttype, total parts using this query