import cs50
from sys import exit, argv

if len(argv) != 2:
    print("invalid number of command line arguments")
    exit(1)
studb = cs50.SQL("sqlite:///students.db")
students = studb.execute("SELECT first, middle, last, birth, house FROM students WHERE house = ?", argv[1])
#students = studb.execute("SELECT first, middle, last, birth, house FROM students WHERE house = ? ORDER BY first", argv[1]) ... order by first name
#students = studb.execute("SELECT first, middle, last, birth, house FROM students WHERE house == Gryffindor")
for wiz in students:
    #if wiz["middle"] == '': #== none?
    if len(wiz) == 3:
        print(wiz["first"], end = " ")
        print(wiz["last"], end = ", ")
        #print(wiz[birth], end = "")
        #print(wiz["birth"], end = "")
        print("born " + str(wiz["birth"]))
    else:
        print(wiz["first"], end = " ")
        print(wiz["middle"], end = " ")
        print(wiz["last"], end = ", ")
        print("born " + str(wiz["birth"]))