最近大模型降价潮,哪家才是真的“价美”也“物美”?
1、晒出评测效果截图(必答)
问题为:SELECT A.zdid AS id, A.zdmc AS name, A.zdbm AS code, A.pic AS picture, A.bz AS remark, B.zdmc AS parent_name, B.zdid AS parent_id, B.zdbm AS parent_code, B.pic AS parent_picture, C.zdmc AS grand_name, C.zdid AS grand_id, C.zdbm AS grand_code, C.pic AS grand_picture,-- COUNT(DISTINCT CASE WHEN t1.table_name = 'farm_plant_protection_detail' THEN t1.item_type END) AS item_type_count count(D.crops_second_code) AS pest_countFROM 'user-center'.sys_dict_tm A LEFT JOIN 'user-center'.sys_dict_tm B ON A.sjid = B.zdid LEFT JOIN 'user-center'.sys_dict_tm C ON B.sjid = C.zdid left join farm_info_crops_pest D ON A.zdbm = D.crops_second_codeGROUP BY A.zdbmWHERE A.ZYLBBM = 'crops_type' AND A.SCBJ = '0' AND A.JYBJ = '0' AND C.zdid IS NOT NULL-- AND A.zdmc like concat('%','番','%')ORDER BY A.pxh, A.zdid;这个pgsql哪里错了左右两个模型给出的答案为
2、对各家模型效果进行点评(必答)
首先生成速度,左边这个模型完胜右边这个模型,左边在提交问题后就有了输出,而且输出速度远远快于右边这个模型,其次左边这个模型看出了pgsql没有分组这个问题,右边这个没有看出来,这样看下来左边模型在这个问题上优于右边这个模型
赞3
踩0