import sqlite3

conn = sqlite3.connect('students.db')
cursor = conn.cursor()
cursor.execute('create table user(id varchar(20) primary key, name varchar(20), score int)')
cursor.execute(r"insert into user values ('A-001', 'Adam', 95)")
cursor.execute(r"insert into user values ('A-002', 'Bart', 62)")
cursor.execute(r"insert into user values ('A-003', 'Lisa', 78)")
cursor.close()
conn.commit()
conn.close()

def get_score_in(low,high):    
    try:
        L = []
        i = 0        
        conn = sqlite3.connect('students.db')
        cursor = conn.cursor()
        cursor.execute('select name from user where score between %s and %s order by score' %(low,high))
        values = cursor.fetchall()
        while i < len(values):        
            L.append(values[i][0])
            i = i + 1
    finally:
        cursor.close()
        conn.close()
    return L
assert get_score_in(80, 95) == ['Adam'], get_score_in(80, 95)
assert get_score_in(60, 80) == ['Bart', 'Lisa'], get_score_in(60, 80)
assert get_score_in(60, 100) == ['Bart', 'Lisa', 'Adam'], get_score_in(60, 100)
print('Pass')