and { only { filter_eq { filter_eq { all_rows ; location ; tokyo } ; res ; loss } } ; eq { hop { filter_eq { filter_eq { all_rows ; location ; tokyo } ; res ; loss } ; opponent } ; hitomi akano } } = true
select the rows whose location record fuzzily matches to tokyo . among these rows , select the rows whose res record fuzzily matches to loss . there is only one such row in the table . the opponent record of this unqiue row is hitomi akano .