mybatis语法包含where 包含连表，包含多条件，包含除法，包含过滤

<select id="selectDepartmentdoctor" parameterType="com.amenuo.yiliao.bean.departmentdoctorPO" resultType="com.amenuo.yiliao.bean.DoctorScorPo">
        SELECT
        usr.id,
        usr.realname,
        usr.user_img_url  userImgUrl,
        usr.longitude,
        usr.latitude,
        usr.begoodat,
        doc.Doctor_score/5 Doctorscore
        FROM
        tb_user_department dep
        LEFT JOIN tb_userdetail usr ON dep.user_id = usr.id
        LEFT JOIN tb_doctorscore doc ON doc.userid = usr.id
        LEFT JOIN tb_user us ON us.id=usr.id
        <where>
             dep.department_code = #{departmentcode}
            <if test="city !=null">
                AND usr.address LIKE  concat('%',#{city,jdbcType=VARCHAR},'%')
            </if>
            <if test="Frequency!=null">
                ORDER BY doc.Frequency DESC
            </if>
            <if test="Doctor_score!=null">
                ORDER BY doc.Doctor_score DESC
            </if>
            and  !ISNULL(usr.latitude) and !ISNULL(usr.latitude)  and us.delete_flag ='N'
        </where>

    </select>