Capital Humano 02

fit. CREATE Variable `SubmitOrderRequestTop20Inaccurate` As Bigint DEFAULT '0'; CREATE Variable `NumberPartialOrders` As Int DEFAULT '0'; SELECT ORDERID, PRODUCTID, ORDERDATE, SHIPDATE, ORDERSTATUS, FROM TBL_ORDERS WHERE ORDERSTATUS IN ('Partial','In Process') AND ORDERDATE > DATEADD(yy, -1, CURRENT_DATE) GROUP BY PRODUCTID HAVING COUNT(ORDERID) > 20 LIMIT 20; SET SubmitOrderRequestTop20Inaccurate = LAST_INSERT_ID(); UPDATE TBL_HIGHRISKORDERS SET SUBMITTED = 1 WHERE ORDERID IN (SELECT ORDERID FROM TBL_ORDERS WHERE ORDERDATE <= NOW() AND ORDERID = SubmitOrderRequestTop20Inaccurate) AND SUBMITTED = 0; SELECT @NumberPartialOrders = COUNT(ORDERID) FROM TBL_ORDERS WHERE ORDERSTATUS = 'Partial'; fit. SELECT CUSTID, NAME, ADDRESS, CITY, STATE, ZIP, COUNTRY, PHONE FROM TBL_CUSTOMERS WHERE CUSTID IN (SELECT CUSTID FROM TBL_ORDERS WHERE ORDERSTATUS = 'Open' AND ORDERDATE > DATEADD(mm, -6, CURRENT_DATE)) ORDER BY CUSTID ASC; DECLARE CURSOR Cust_Cur IS SELECT CUSTID, NAME, SUM(ORDERTOTAL) AS TOTALSPENT FROM TBL_CUSTOMERS JOIN TBL_ORDERS USING(CUSTID) WHERE ORDERSTATUS = 'Complete' GROUP BY CUSTID, NAME HAVING TOTALSPENT > 10000; OPEN Cust_Cur; FETCH CURSOR Cust_Cur INTO Cust_ID, Cust_Name, Cust_Spent; CLOSE Cust_Cur; COMMIT;