core reorg

[csql.git] / test / sql / Aggregate / sales_join_aggregate2.sql

echo select sales_order_details.productno,description,qtyordered,name from sales_order_details, sales_order, product_master, client_master where sales_order.orderno=sales_order_details.orderno and product_master.productno=sales_order_details.productno and client_master.clientno=sales_order.clientno and name='Ivan Bayross' and name='Mamta Muzumdar';
select sales_order_details.productno,description,qtyordered,name from sales_order_details, sales_order, product_master, client_master where sales_order.orderno=sales_order_details.orderno and product_master.productno=sales_order_details.productno and client_master.clientno=sales_order.clientno and name='Ivan Bayross' and name='Mamta Muzumdar';
  
echo select sales_order_details.productno,description,min(qtyordered), max(qtyordered), count(qtyordered), sum(qtyordered) from sales_order_details, sales_order, product_master, client_master where sales_order.orderno=sales_order_details.orderno and product_master.productno=sales_order_details.productno and client_master.clientno=sales_order.clientno and name='Ivan Bayross' and name='Mamta Muzumdar' group by sales_order_details.productno,description;  
select sales_order_details.productno,description,min(qtyordered), max(qtyordered), count(qtyordered), sum(qtyordered) from sales_order_details, sales_order, product_master, client_master where sales_order.orderno=sales_order_details.orderno and product_master.productno=sales_order_details.productno and client_master.clientno=sales_order.clientno and name='Ivan Bayross' and name='Mamta Muzumdar' group by sales_order_details.productno,description;