How can you insert data into a Snowflake table using SQL? Give an example INSERT statement.

You can insert data into a Snowflake table using the **`INSERT INTO`** statement. Here's an example of how to use the **`INSERT INTO`** statement to add data to a table:

Assuming you have a table named **`Employees`** with columns **`EmployeeID`**, **`FirstName`**, **`LastName`**, **`Department`**, and **`Salary`**, you can insert a new employee record like this:

```sql
sqlCopy code
INSERT INTO Employees (EmployeeID, FirstName, LastName, Department, Salary)
VALUES (1, 'John', 'Doe', 'Sales', 55000.00);

```

In this example:

- **`INSERT INTO Employees`** specifies the target table where the data will be inserted.
- **`(EmployeeID, FirstName, LastName, Department, Salary)`** lists the columns you're inserting data into, in the same order they appear in the table.
- **`VALUES (1, 'John', 'Doe', 'Sales', 55000.00)`** provides the values to be inserted into each corresponding column.

You can also insert multiple rows in a single **`INSERT INTO`** statement:

```sql
sqlCopy code
INSERT INTO Employees (EmployeeID, FirstName, LastName, Department, Salary)
VALUES
(2, 'Jane', 'Smith', 'Marketing', 60000.00),
(3, 'Michael', 'Johnson', 'HR', 52000.00),
(4, 'Emily', 'Williams', 'Finance', 65000.00);

```

In this case, each set of values in parentheses represents a separate row to be inserted.

Keep in mind that the **`INSERT INTO`** statement is used for inserting new rows into a table. If you want to update existing rows or insert new rows based on certain conditions, you would use the **`INSERT INTO ... SELECT`** statement, which allows you to insert data from another table or result set.

Remember to adjust the table name, column names, and values based on your specific table structure and data.