what are the players whose former teams are carolina cobras and scottish claymores ?
SELECT DISTINCT var_uri where brack_open var_uri dbo_formerTeam dbr_Carolina_Cobras sep_dot var_uri dbo_formerTeam dbr_Scottish_Claymores brack_close