Brian Vuyk wrote:
1.) We are including extra data from the users table (wasn't central to the question, so I omitted it to simplify)Create a second table where the role id's have a weight for their capability level2.) How would you structure this exactly with subquery?
