sql_task.py

# -*- coding: utf-8 -*-
"""sql_task.py

Automatically generated by Colab.

Original file is located at
    https://colab.research.google.com/drive/1w8HPEO28aX6JRO7WpVPPI0ctVuswKCxg
"""

import sqlite3

conn = sqlite3.connect("students.db")
cursor = conn.cursor()

# Create table
cursor.execute("""
CREATE TABLE IF NOT EXISTS students (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT,
    marks INTEGER
)
""")

# Insert sample data
cursor.execute("DELETE FROM students")  # prevent duplicates
cursor.execute("INSERT INTO students (name, marks) VALUES ('Ravi', 85)")
cursor.execute("INSERT INTO students (name, marks) VALUES ('Priya', 92)")
cursor.execute("INSERT INTO students (name, marks) VALUES ('Kiran', 70)")
conn.commit()

print("Student Database Ready")

limit = int(input("Enter marks limit to find students below that: "))

cursor.execute("SELECT name, marks FROM students WHERE marks < ?", (limit,))
results = cursor.fetchall()

print(f"\nStudents who scored less than {limit}:")

for r in results:
    print("Name:", r[0], "| Marks:", r[1])

conn.close()