and { greater { hop { filter_eq { all_rows ; date ; 19 november 1997 } ; score } ; hop { filter_eq { all_rows ; date ; 19 november 2003 } ; score } } ; and { eq { hop { filter_eq { all_rows ; date ; 19 november 1997 } ; score } ; 1 - 0 } ; eq { hop { filter_eq { all_rows ; date ; 19 november 2003 } ; score } ; 0 - 3 } } } = true
select the rows whose date record fuzzily matches to 19 november 1997 . take the score record of this row . select the rows whose date record fuzzily matches to 19 november 2003 . take the score record of this row . the first record is greater than the second record . the score record of the first row is 1  0 . the score record of the second row is 0  3 .