How to: Remove duplicate TITLES but keep a COUNTRY code

Hi, I've just been reading through the How to Retrieve Data from a Single Table and was wondering if someone could help with the following as I cant seem to find the answer to what is probably an easy question for the experts. I'm a Visual FoxPro 6 user and use the following code to almost accomplish what I'm after

SELECT * FROM mytabletemp INTO TABLE LISTINGS GROUP BY TITLE

This works perfectly and removes any duplicate entries with the same TITLE
My problem (and yes it's been a problem!) is that I have four possible country of ORIGIN codes such EEC - USA - CAN - DOM

What I'm trying to do is search out any duplicate TITLES as shown below but keep the USA ones
Example:

ADAMS, BRYAN - BEST OF - EEC
ADAMS, BRYAN - BEST OF - USA
ADAMS, BRYAN - BEST OF - CAN
ADAMS, BRYAN - BEST OF - DOM

How do I remove three of the above just keeping the USA title?
I would be more than grateful if anyone can suggest the answer
Kindest regards
Lee