Product                                          vendor
id        name    fkvid                         id       name
1         a          1                          1        va
2         b          1                          2        vb
3         c          3                          3        vc


How many products does each vendor deliver?

select    ven.name ,count(p.fkvid)   from Product pod ,vendor  ven  where    pod.fkvid = ven.id group by ven.name ,pod.fkvid

2 Questions ::
1 is above mentioned query  right?

2 in Hibernate 1 to Many relationship , how to convert it ?