Here is my table
DrugId | BrandGeneric | Coutnry
=============================================
1 brand US
1 brand France
1 generic US
1 generic France
1 brand germany
My goal is to return all branded drugs that do not have a generic in the same country,
hence the last record would be returned because there is no generic drug in germany.