How to find Last_name by id in SQlite database?

Question

Python

There is a table reg_studs with columns id, first_name, last_name, group . You need to know first_name by ID . id_studs - student ID.

The code I wrote doesn't work. Where did I go wrong?

def get_name_student(id_studs):
  conn = get_connection()
  c = conn.cursor()
  c.execute("""
    SELECT reg_studs.id_studs, reg_studs.last_name
    FROM reg_studs
    WHERE (((reg_studs.id)= id_studs));
    """)

Answer 1

You are not formatting the request correctly.
You need it like this:

def get_name_student(id_studs):
  conn = get_connection()
  c = conn.cursor()
  c.execute('SELECT first_name FROM reg_studs WHERE id=?', id_studs)