I have an assessment table newassessment having the following columns. assessmentid integer, assdate varchar2(10), suppname varchar2(255),...

I have an assessment table newassessment having the following columns. assessmentid integer, assdate varchar2(10), suppname varchar2(255), critno varchar2(10), assrate integer Each supplier can have a number of assessments for each criteria number (the criteria numbers range from 1-10) and the assesment rate can be a number 1-5 For example for Supplier A an assessment on 02/02/2001 Critno- assrate 1 - 2 2-4 3-5 4-3 5-2 For supplier A an assessment on 10/02/2001 Critno - assrate 1-1 2-1 3-4 4-3 5-2 I now need to obtain an output which contains only the assessment values from the last assessment for each supplier. Then using these values I have to find the number of suppliers having rating 1,2,3,4,5 separately. Thanks in advance