Sqlite3. Что не так с запросом?

cur.execute("UPDATE marks SET mark = :Mark JOIN marks ON students students.id = marks.id WHERE subject LIKE " 
                "'Физра' AND students.id = 5", 
                {'Mark': 4})

import sqlite3 as sql 
 
stud = [ 
    ('Коля', 1, 17), 
    ('Маша', 2, 16), 
    ('Вася', 1, 19), 
    ('Даша', 2, 18), 
    ('Алена', 2, 17) 
] 
 
marks_ = [ 
    (1, 'Си', 4), 
    (1, 'Физика', 3), 
    (1, 'Вышка', 5), 
    (1, 'Физра', 5), 
    (2, 'Си', 3), 
    (2, 'Вышка', 4), 
    (2, 'Химия', 3), 
    (3, 'Си', 4), 
    (3, 'Черчение', 3), 
    (3, 'Физика', 5), 
    (5, 'Физра', 3) 
] 
 
with sql.connect("test4.db") as con: 
    cur = con.cursor() 
    cur.execute("DROP TABLE IF EXISTS students") 
 
    cur.execute("DROP TABLE IF EXISTS students") 
    cur.execute("DROP TABLE IF EXISTS marks") 
 
    cur.execute("""CREATE TABLE IF NOT EXISTS students ( 
        id INTEGER PRIMARY KEY AUTOINCREMENT, 
        name TEXT, 
        sex INTEGER, 
        old INTEGER 
    ) 
    """) 
 
    cur.execute("""CREATE TABLE IF NOT EXISTS marks ( 
            id INTEGER, 
            subject TEXT, 
            mark INTEGER 
        ) 
        """) 
 
    cur.executemany("INSERT INTO students VALUES (NULL, ?, ?, ?)", stud) 
    cur.executemany("INSERT INTO marks VALUES (?, ?, ?)", marks_) 
 
    cur.execute("UPDATE marks SET mark = :Mark JOIN marks ON students students.id = marks.id WHERE subject LIKE " 
                "'Физра' AND students.id = 5", 
                {'Mark': 4}) 
 
    cur.execute("SELECT * FROM marks") 
    result2 = cur.fetchall() 
    print(result2)

cur.execute("UPDATE marks SET mark = :Mark (students JOIN marks ON students.id = marks.id) WHERE subject LIKE "
                "'Физра' AND students.id = 5",
                {'Mark': 4})

cur.execute('''\
UPDATE marks SET
    mark = :mark
WHERE
    id = :student_id
AND subject = :subject
''', {
    'student_id': 5,
    'subject': 'Физра',
    'mark': 4,
});