where e.order_no=f.order_no) g group by cust_id having count(distinct prod_id)>=3) h) 为什么要加h?select a.cust_id,cust_name,b.prod_id,prod_name,d.qty,d.qty*d.unit_pricefrom customer a,product b,sales c,sale_item dwhere a.cust_id=c.cust_id and d

来源:学生作业帮助网 编辑:作业帮 时间:2024/08/03 02:27:37
xS]K@+>vJI3$`'IVѺEkYAE+(ѠLLL/˽{ϹDu &bSiصVJ`Am߁"5,6ot'^YgڈWzmVSzYb߆'aާ)mʮ6]۰<I+F< @jVK<\dDIn ԊUD^@G{PrAJYeܶ"a|ޑ%-x}E˳Vxak[lgK6m%;*])ݰsuߘ.߲X ecMH1t6AEGh|H ݂jvEWw q|l'e}_3X/wڹڝ.qn}UH==_t