2 # Testing Join on 5 sales tables.
3 # Create 5 tables like client_master,product_master,salesman_master,sales_order,sales_order_details.
4 # populate the above tables with required values.
5 # Test join, aggregate and having on them by executing the following query:
6 # List average qty sold for each client that has average of qty sold >3average of qty sold >3. Same apply for count,min,max and sum.
8 QUITFILE
=${PWD}/sql
/Aggregate
/quit.sql
12 REL_PATH
=`pwd`/sql
/Aggregate
15 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/sales_tables.sql
18 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/sales_table_drop.sql
22 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/sales_join_aggregate.sql
25 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/sales_table_drop.sql
29 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/sales_table_drop.sql