Business Analyst: What is a SQL INSERT statement?

1-- Single row
2INSERT INTO customers (name, email)
3VALUES ('John Doe', 'john@example.com');
4
5-- Multiple rows
6INSERT INTO products (name, price)
7VALUES
8  ('Widget A', 9.99),
9  ('Widget B', 19.99);
10
11-- From another table
12INSERT INTO archive_orders
13SELECT * FROM orders WHERE year < 2023;