insert query with select statement

Please send me your query...

SQL INSERT INTO SELECT Examples

INSERT INTO Customers (CustomerName, Country)
SELECT SupplierName, Country FROM Suppliers;


And
INSERT INTO Customers (CustomerName, Country)
SELECT SupplierName, Country FROM Suppliers
WHERE Country='Germany';