and { only { filter_eq { filter_eq { all_rows ; captain ; a simpson } ; chairman ; j magowan } } ; eq { hop { filter_eq { filter_eq { all_rows ; captain ; a simpson } ; chairman ; j magowan } ; year } ; 2007 } } = true
select the rows whose captain record fuzzily matches to a simpson . among these rows , select the rows whose chairman record fuzzily matches to j magowan . there is only one such row in the table . the year record of this unqiue row is 2007 .