and { only { filter_eq { filter_eq { all_rows ; date ; nov } ; result ; loss } } ; eq { hop { filter_eq { filter_eq { all_rows ; date ; nov } ; result ; loss } ; opponent } ; 1 tennessee } } = true
select the rows whose date record fuzzily matches to nov . among these rows , select the rows whose result record fuzzily matches to loss . there is only one such row in the table . the opponent record of this unqiue row is 1 tennessee .