The group by type is what I needed. Now I know where to come for help with my intro to mysql class
I think I screwed myself on a couple of questions because we're only allowed to use things we've covered so far in the book but I used some other way I found out but oh well. Easy 4.0 in this class.