Like we used the fetch methods, we can also use a for loop to retrieve data. The following code will iterate through each row in the students table and print each row where the Grade field is 'Pass'.

for row in cursor.execute('''SELECT * FROM students WHERE Grade = 'Pass';'''):
   print(row)

You can also use a for loop to iterate through a table field and calculate a measurement.

# save all rows from a field with .fetchall() then use a for loop to find some sort of result.`
major_codes = cursor.execute("SELECT major_code FROM students;").fetchall()


# Obtain the average of the tuple list by using for loops
sum = 0
for num in major_codes: 
  sum = sum + num[0]
average = sum / len(major_codes)

# Show average
print(average)

Let’s walk through this example code:

• We used a SQL statement to retrieve the major code field from the students table.
• We created the variable sum initialized at 0, to sum up the total values in the data.
• We used a for loop to iterate through every number in major_code to create the mean average major_code.
• We add num[0] to sum at each iteration. Note that num is a tuple of length 1 (such as (12,)) so num[0] will allow us to access the actual integer.
• We find the average by dividing sum and the length of major_codes.