查询发生过10笔以上公赏业务的客户,表名∶ con_contract(注∶贷款合同表)

发布于 2021-02-19 02:39:50
【单选题】
A SELECT CUSTOMER_NUM,COUNT (CONTRACT_ID) cnt_con FROM con_contract GROUP BY CUST0MER_NUM HAVING cnt_con>10
B SELECT CUSTOMER_NUM,CUSTOMER NAME,COUNT (CONTRACT_ID) cnt_con FROM con_contract WHERE cnt_con > 10 GROUP BY CUSTOMER_NUM
C SELECT CuSTOME_NUM_COUNT (CONTRACT_ID)) cnt_con FROM con_contract WHERE cnt_con >10 GROUP BY CUSTOMER_NUM
D SELECT CUSTOMER_NUM,CUSTOMER_NAME,COUNT (CONTRACT_ID) cnt_con FROM con_contract GROUP BY CUSTOMER_NUM HAVING cnt_con>10

查看更多

关注者
0
被浏览
88
  • 体验AI问答!更聪明、超智能!
  • 一款基于GPT的超级AI助手,可以对话、创作、写文案!
1 个回答

撰写答案

请登录后再发布答案,点击登录

发布
问题

手机
浏览

扫码手机浏览

分享
好友

在线
客服