select 100 * count(custID)/(select count(*)
from customerorder)as goodorderpercentage
from customerorder o, product p
where productcount*price>1000
and o.productID = p.productID;
原帖由 steve123456789 於 2007-7-20 11:38 AM 發表
select 100 * count(custID)/(select count(*)
from customerorder)as goodorderpercentage
from customerorder o, product p
where productcount*price>1000
and o.productID = p.productID;