Select a1.title title, a1.internet_url, count(a2.internet_url) hitsno, a1.ref_pk
from mis_internet a1, mis_internet_log a2
where a1.internet_url = a2.internet_url 
and a2.date_stamp >= sysdate-60
group by a1.title, a1.internet_url, a1.ref_pk
order by count(a2.internet_url) desc

Business Development (Word)                                 	www.google.com.au                                           	5564                                   	3516
Search Engine - Google                                      	www.google.com.au                                           	5564                                   	1042
Google                                                      	www.google.com                                              	5487                                   	2377
Sydney Morning Herald                                       	www.smh.com.au                                              	3478                                   	36
Sydney Morning Herald Online                                	www.smh.com.au                                              	3478                                   	1299
Sydney Morning Herald                                       	www.smh.com.au                                              	3478                                   	3407
Bureau of Meteorology                                       	www.bom.gov.au                                              	3131                                   	1167