OperationalError

Traceback $($most recent call last$)$

Cell In$[80],$ line $23$

$15$ cur $=$ conn.cursor$()$

$16\}\backslash$mathrm$\{$ cur.execute$(\text{'}\text{'}\text{'}$CREATE TABLE IF NOT EXISTS employees $($

$17$ employee$\_$id INTEGER PRIMARY KEY,

$18$ first$\_$name TEXT,

$(...)$

$22)\text{'}\text{'}\text{'})$

$--->23$ cur.executemany$(\text{'}$INSERT OR IGNORE INTO employees VALUES $(?,?,?,?,?)\text{'},$

$[(1,$ 'John', 'Doe', $\text{'}$HR$\text{'},50000),$

$(2,$ 'Jane', 'Smith', $\text{'}$IT$\text{'},75000),$

$(3,$ 'Mike', 'Brown', 'Finance', $62000),$

$(4,$ 'Emily', 'Davis', 'Marketing', $58000)])$

conn.commit$()$

print$("$employees with a salary above $60000$:$")$

OperationalError: table employees has $2$ columns but $5$ values were supplied

Dow below it is the full code

import sqlite$3$

conn $=$ sqlite$3.$connect$(\text{'}$company$.$db$\text{'})$

cur $=$ conn.cursor$()$

cur.execute$(\text{'}\text{'}\text{'}$CREATE TABLE IF NOT EXISTS employees $($

employee$\_$id INTEGER PRIMARY KEY,

first$\_$name TEXT,

last$\_$name TEXT,

department TEXT,

salary REAL

$)\text{'}\text{'}\text{'})$

cur.executemany$(\text{'}$INSERT OR IGNORE INTO employees VALUES $(?,?,?,?,?)\text{'},$

$[(1,$ 'John', 'Doe', $\text{'}$HR$\text{'},50000),$

$(2,$ 'Jane', 'Smith', $\text{'}$IT$\text{'},75000),$

$(3,$ 'Mike', 'Brown', 'Finance', $62000),$

$(4,$ 'Emily', 'Davis', 'Marketing', $58000)])$

conn.commit$()$

print$("$employees with a salary above $60000$:$")$

cur.execute$(\text{'}$SELECT $*$ FROM employees WHERE salary $>60000\text{'})$

employees$\_$with$\_$high$\_$salary $=$ cur.fetchall$()$

for row in employees$\_$with$\_$high$\_$salary:

print$($row$)$

cur.execute$(\text{'}$UPDATE employees SET salary $=65000$ WHERE employee$\_$id $=3\text{'})$

conn.commit$()$

cur.execute$(\text{'}$DELETE FROM employees WHERE employee$\_$id $=4\text{'})$

conn.commit

print$("$

Updated employees List:"$)$

cur.execute$(\text{'}$SELECT $*$ FROM employees'$)$

updated$\_$employees $=$ cur.fetchall$()$

for row in updated$\_$employees:

print$($row$)$

conn.close$()$

After the full code, I can't still see the issue on the code since I've tried to separate or find the missing columns, thank you.