classify lake of the hirsel
(AND geography.lake_type (JOIN geography.lake_type.lakes_of_this_type m.07f_qd))