Your insert failed because in the line below, you're missing a quote after Ray:

To get the count of each row:

select page, COUNT(*) row_count

from visited

group by page;