sql query in code example

Example: in query in sql

SELECT Id, FirstName, LastName, Country  FROM Customer WHERE Country IN        (SELECT Country           FROM Supplier)