场景洞察0217需求

入参：作为3.1接口入参<br>

<span style="font-weight:normal;">注意：</span>&lt;&gt;未知、is not null、common_conditions公有查询条件等情况<br>

select user_sex as `key`, count(distinct mid) as `value`<br>&nbsp; &nbsp; &nbsp; &nbsp; from iceberg_zjyprc_hadoop.mi_car.ads_usr_profile_crowd_data_di<br>&nbsp; &nbsp; &nbsp; &nbsp; <b>&lt;if test="tableName != null and tableName != ''"&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; INNER JOIN tableName ON tableName.mid = iceberg_zjyprc_hadoop.mid<br>&nbsp; &nbsp; &nbsp; &nbsp; &lt;/if&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp; WHERE 1=1<br>&nbsp; &nbsp; &nbsp; &nbsp; &lt;if test="tableName != null and tableName != ''"&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; and tableName.#{fieldName} = #{fieldValue}<br>&nbsp; &nbsp; &nbsp; &nbsp; &lt;/if&gt;</b><br>&nbsp; &nbsp; &nbsp; &nbsp; &lt;include refid="common_conditions"/&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp; and user_sex &lt;![CDATA[ &lt;&gt; ]]&gt; '未知'<br>&nbsp; &nbsp; &nbsp; &nbsp; group by user_sex<br>&nbsp; &nbsp; &nbsp; &nbsp; order by case user_sex<br>&nbsp; &nbsp; &nbsp; &nbsp; when '男' then 1<br>&nbsp; &nbsp; &nbsp; &nbsp; when '女' then 2<br>&nbsp; &nbsp; &nbsp; &nbsp; else 3<br>&nbsp; &nbsp; &nbsp; &nbsp; end<br>

示例：[<br>["111111", "222222"],<br>["33333", "444444"]<br>]<br>

示例：{<br>"dataType": "Leads",<br>"channelName": [],<br>"cityNameList": [],<br>"activityNameList": [],<br>"shopNameList": [],<br>"startDate": 1738368000000,<br>"endDate": 1740960000000,<br>"linkageCondition": [{<br>"tableName": "aaa",<br>"fieldName": "user_sex",<br>"fieldValue": "男",<br>"linkageSort": 1<br>}, {<br>"tableName": "bbb",<br>"fieldName": "car_ecosystem_car_prduct",<br>"fieldValue": "轻量棒球帽",<br>"linkageSort": 2<br>}]<br>}<br>