use context essentials2021
# Important: include this line whenever working with Tables!
# (from https://hackmd.io/@cs111/table)
include shared-gdrive("dcic-2021", "1wyQZj_L0qqV9Ekgr9au6RX2iqt2Ga8Ep")

# Function from last time
fun print-makeup-3(student-row :: Row) -> Boolean:
  is-SNC = student-row["SNC"]
  quiz1 = student-row["quiz1"]
  quiz2 = student-row["quiz2"]
  not(is-SNC) and ((quiz1 < 62) or (quiz2 < 70))
where:
  print-makeup-3(viktorija-row) is true
  print-makeup-3(pranav-row) is false
end

gradebook = table: name, semester, SNC, quiz1, quiz2
  row: "Ursa", 3, false, 83, 56
  row: "Isaias", 4, true, 92, 79
  row: "Jackson", 8, true, 61, 0
  row: "Isi", 7, false, 90, 87
  row: "Thuy", 5, false, 85, 85
  row: "Brigida", 5, false, 0, 0
end

# Extracting a row
ursa-row = gradebook.row-n(0)
# Extracting a cell value
ursa-quiz1-score = ursa-row["quiz1"] # 83