Как удалить значение используя метод DELETE

@app.route('/template', methods=['GET','POST','DELETE'])
def template():
    if request.method == 'POST':

        with sq.connect("dota.bd") as con:

            cur = con.cursor()
            cur.execute("""CREATE TABLE IF NOT EXISTS users( INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,fname TEXT, lname TEXT, gender TEXT);""")
            cur.execute("""INSERT INTO users (gender) VALUES ('m') """)
            


    if request.method == 'DELETE':

        with sq.connect("dota.bd") as con:

            cur = con.cursor()
            cur.execute("""CREATE TABLE IF NOT EXISTS users( INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,fname TEXT, lname TEXT, gender TEXT);""")
            cur.execute(""" DELETE FROM users WHERE ID in(SELECT MAX(ID) FROM users)  """)