and { only { filter_greater { filter_eq { all_rows ; years ; 196 } ; total ; 600 } } ; eq { hop { filter_greater { filter_eq { all_rows ; years ; 196 } ; total ; 600 } ; name } ; joe corrigan } } = true
select the rows whose years record fuzzily matches to 196 . among these rows , select the rows whose total record is greater than 600 . there is only one such row in the table . the name record of this unqiue row is joe corrigan .