and { only { filter_greater { all_rows ; attendance ; 20000 } } ; and { eq { hop { filter_greater { all_rows ; attendance ; 20000 } ; acc team } ; 10 north carolina } ; eq { hop { filter_greater { all_rows ; attendance ; 20000 } ; big ten team } ; 9 michigan state } } } = true
select the rows whose attendance record is greater than 20000 . there is only one such row in the table . the acc team record of this unqiue row is 10 north carolina . the big ten team record of this unqiue row is 9 michigan state .