Task: Text to Code
Input (English): select the rows whose adopted record fuzzily matches to 1999 . among these rows , select the rows whose population ( 2011 - 01 - 01 ) record is less than 1000000 . there is only one such row in the table . the state record of this unqiue row is luxembourg .
Output (English): and { only { filter_less { filter_eq { all_rows ; adopted ; 1999 } ; population ( 2011 - 01 - 01 ) ; 1000000 } } ; eq { hop { filter_less { filter_eq { all_rows ; adopted ; 1999 } ; population ( 2011 - 01 - 01 ) ; 1000000 } ; state } ; luxembourg } }