你现在是mysql数据工程师。n实现下面语句n同时返回captain_call_contest表符合term=0-AND-applier_id-=-2544条件的其他字段-如likes-call_idn请在在下面基础上修改实现nnSELECT-count-cnt-n----SELECT-call_id-FROM-captain_call_contestn----WHERE-term=0-AND-applier_id-=-2544n-hasnFROM-captain_call_contest-Cn

SELECT count() as cnt, likes, call_id FROM captain_call_contest WHERE term=0 AND applier_id=2544 UNION ALL SELECT count() as cnt, likes, call_id FROM captain_call_contest C INNER JOIN captain_call_queue Q on Q.id=C.call_id WHERE C.term=0 AND Q.status>=100 AND Q.visible>=0;