Task: Text to Code
Input (English): select the rows whose party record fuzzily matches to republican . among these rows , select the rows whose result record fuzzily matches to lost . there is only one such row in the table . the incumbent record of this unqiue row is dan crane .
Output (English): and { only { filter_eq { filter_eq { all_rows ; party ; republican } ; result ; lost } } ; eq { hop { filter_eq { filter_eq { all_rows ; party ; republican } ; result ; lost } ; incumbent } ; dan crane } }