import sqlite3

conn = sqlite3.connect('sample.db')
cur = conn.cursor()

print('weight列で軽い順（昇順）に並べ替える')
sql = """SELECT *
  FROM personal
  ORDER BY weight ASC"""
for row in cur.execute(sql):
  print(row)
print()   # 改行

print('height列で背の高い順（降順）に並べ替える')
sql = """SELECT *
  FROM personal
  ORDER BY height DESC"""
for row in cur.execute(sql):
  print(row)

conn.close()
