Your table have not any duplicate records ..
that have only Clubname & ID are same but Last Name & First Name are Different .. So your query will retrieve all values ..
if you want to retrieve group distinct use this query ..
select clubname,id,lastname,firstname from persons group by clubname
Thanks
AARIF SHAIKH