Stuck with a query...

Hi folks,

Sorry to ask a newbie SQL question but I'm struggling...

I have a website clickstream log:

request_id   session_id  sequence_num  url
100          xxx         1             /foo
101          xxx         2             /bar
102          xxx         3             /hoo
103          yyy         1             /foo
104          yyy         2             /bar

I need to count the number of times each url was an exit
page. An exit page is the highest sequence_num for each
session_id - 102 & 104 in the example. The report would look
like:

Exit pages:

/foo 4555
/bar 3204
/hoo 2337

etc...

Any pointers would be much appreciated!

------------------
Geoff Caplan
Vario Software Ltd
(+44) 121-515 1154