test/sql/Aggregate/sales_join_aggregate.sql

   1 echo select client_master.clientno,name,count(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name;
   2 select client_master.clientno,name,count(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name;
   3 echo select client_master.clientno,name,count(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name having count(qtydisp)>3;
   4 select client_master.clientno,name,count(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name having count(qtydisp)>3;
   5 echo select client_master.clientno,name,min(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name;
   6 select client_master.clientno,name,min(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name;
   7 echo select client_master.clientno,name,min(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name having min(qtydisp)<3;
   8 select client_master.clientno,name,min(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name having min(qtydisp)<3;
   9 echo select client_master.clientno,name,max(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name;
  10 select client_master.clientno,name,max(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name;
  11 echo select client_master.clientno,name,max(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name having max(qtydisp)>4;
  12 select client_master.clientno,name,max(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name having max(qtydisp)>4;
  13 echo select client_master.clientno,name,sum(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name;
  14 select client_master.clientno,name,sum(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name;
  15 echo select client_master.clientno,name,sum(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name having sum(qtydisp)>3;
  16 select client_master.clientno,name,sum(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name having sum(qtydisp)>3;
  17 echo select client_master.clientno,name,avg(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name;
  18 select client_master.clientno,name,avg(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name;
  19 echo select client_master.clientno,name,avg(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name having avg(qtydisp)>3;
  20 select client_master.clientno,name,avg(qtydisp) from sales_order_details,sales_order,client_master where client_master.clientno=sales_order.clientno and sales_order.orderno=sales_order_details.orderno group by client_master.clientno,name having avg(qtydisp)>3;