and { only { filter_less { all_rows ; apparent magnitude ; 10.0 } } ; and { eq { hop { filter_less { all_rows ; apparent magnitude ; 10.0 } ; object type } ; spiral galaxy } ; eq { hop { filter_less { all_rows ; apparent magnitude ; 10.0 } ; constellation } ; ursa major } } } = true
select the rows whose apparent magnitude record is less than 10.0 . there is only one such row in the table . the object type record of this unqiue row is spiral galaxy . the constellation record of this unqiue row is ursa major .