Why am i seeing "column count doesn't match value count at row x" in sql?

Example:

INSERT INTO users (name, age) VALUES ("John");

This error happens when the number of columns doesn’t match the number of values in an INSERT statement.

Solution:

-- Ensure that the number of columns matches the number of values
INSERT INTO users (name, age) VALUES ("John", 30);