Can anyone help with the following question?! Print the top 2 sale for the last two years info 1. Assume the sale order table is in DB2 with the following colums EXEC SQL DECLARE CUSTOMER_SALE TABLE CUST_ID CHAR(6) NOT NULL, SALE_DATE DATE NOT NULL, SALE_AMOUNT DECIMAL(9, 2) NOT NULL 2. The top one sale get 10% bouns of his total sale of that year The top second Sale get 5% bouns of his total sale of that year 3. Print the report below (Include 2015 and 2014) Cust_Id Sale_Date Sale_Amount Bonus ----------- ------------- ------------------ -------- 100001 2015-04-01 $12,000.00 2015-07-01 $18,000.00 The toal $30,000.00 $3000.00 xxxxxxx 2015-02-02 $18,000.00 2015-07-02 $10,000.00 The total $28,000.00 $1400.00 xxxxxxx 2014-04-01 $18,000.00 2014-07-01 $18,000.00 The toal $36,000.00 $3600.00 xxxxxxx 2014-02-02 $18,000.00 2014-07-02 $12,000.00 The total $30,000.00 $1500.00
... View more