Selecting data with SQL

main.py

import sqlite3

conn = sqlite3.connect('school.db')
cursor = conn.cursor()

# cursor.execute('''
#     CREATE TABLE IF NOT EXISTS Students(
#         id INTEGER PRIMARY KEY AUTOINCREMENT,
#         name TEXT,
#         age INTEGER
#     )
# ''')

# name = input("Name: ")
# age = int(input("Age: "))
# phone_number = input("Phone number: ")

# cursor.execute('INSERT INTO Students(name, age, phone_number) VALUES(?, ?, ?)', (name, age, phone_number))

'''selecting all columns'''
# query = 'SELECT * FROM Students'

'''selecting specific column(s)'''
# query = 'SELECT name FROM Students'

'''rename column title'''
# query = 'SELECT name AS student_name FROM Students'

'''using case'''
# query = '''
#     SELECT name, age,
#         CASE
#             WHEN age < 13 THEN 'Toddler'
#             ELSE 'Adult'
#         END AS age_status
#     FROM Students;
# '''

'''get upper case,length, substr,concantenate operator() to add a character(||)'''
# query = '''
#     SELECT name || lastname AS first_initial
#     FROM Students;
# '''

'''mathematical operations(round, )'''
# query = '''
#     SELECT round(grade) AS rounded_grade
#     FROM Students;
# '''

cursor.execute(query)
students_data = cursor.fetchall()
print(students_data)

# conn.commit()
conn.close()