I have two tables:

DRIVER

(Driver_Id,First name,Last name,...)

PARTICIPANT IN CAR ACCIDENT

(Participant_Id,Driver_Id-foreign key,responsibility-yes or no,...)

Now, I need to find out which driver participated in accident where responsibility is 'YES', and how many times. I did this:

Select Driver_ID, COUNT (Participant.Driver_ID)as 'Number of accidents'
from Participant in car accident
where responsibility='YES'
group by Driver_ID
order by COUNT (Participant.Driver_ID) desc

But, I need to add drivers first and last name from the first table(using inner join, I suppose). I don't know how, because it is not contained in either an aggregate function or the GROUP BY clause. Please help :)