NORTHWIND DATABASE MySQL!!!

Post by **answerhappygod** » Thu May 05, 2022 12:46 pm

: Northwind Database Mysql 1 (42.37 KiB) Viewed 52 times

5. Write a stored procedure named printOrderFreights(). The printOrderFreights() procedure should use cursor processing to find those orders whose freight is less than or equal to 0.2 and then print the "Freight is less than or equal to $0.2" message for each and every row that satisfies the condition. Hint: You need to use cursor processing for this stored procedure. Hint: Follow the 5 steps of cursor processing and declare any variables needed.
order_subtotals order_subtotals orderdetails orderdetails orderdetails orderdetails orderdetails orders orders orders orders orders orders orders orders orders orders orders orders orders orders orders_gry orders_gry orders_gry orders_gry orders_gry orders_gry orders_gry orders_gry wprow orders_gry orders_gry wprow orders_gry orders_gry pom orders_gry orders_gry pom orders_gry orders_gry orders_gry orders_gry orders_gry orders_gry product_sales_for_1997 ◇ OrderID → Subtotal > OrderID > ProductID → UnitPrice Quantity → Discount Discount OrderID Orderi CustomerID → → EmployeeID OrderDate RequiredDate Shipped Date → ShinVia ShipVia > Freight ◇ ShipName ◇ ShipAddress ◇ Ship City → ShipRegion → ShipPostal Code → Ship Country > OrderID Ⓒordeno CustomerID V ◇ EmployeeID OrderDate RequiredDate ◇ ShippedDate → ShipVia ◇ > Freight weight ShipName CHAN ShipAddress ampado Ship City ShipRegion ShipPostal Code CH > Ship Country CompanyName www Address > City Region. Postal Code Country CategoryName int decimal(35,2) int int m decimal(10,2) smallint float int me varchar(5) int int date date date int int decimal(10,2) varchar(40) varchar(60) varchar(15) varchar(15) varchar(10) varchar(15) int int ww varchar(5) int int date date date int decimal(10,2) varchar(40) www varchar(60) vorcion varchar(15) vorciante! varchar(15) archana! varchar(10) Carchar(20) varchar(15) war chance! varchar(40) varchar(60) varchar(15) varchar(15) varchar(10) varchar(15) varchar(15) 0.00 1 0 0.00 0.00 NO YES NO NO NO NO NO NO NO NO NO NO NO YES ILS utf8mb4 YES 123 YES TES YES 163 YES 13 YES 143 YES 13 YES utf8mb4 163 YES YES utf8mb4 YES YES utf8mb4 utf8mb4 YES YES TES utf8mb4 YES utf8mb4 T NO NO YES utf8mb4 TLS YES TES YES 13 YES 163 YES TES YES YES YES utf8mb4 YES YES YES YES YES utf8mb4 utf8mb4 utf8mb4 utf8mb4 www.me utf8mb4 utf8mb4 wwwm utf8mb4 utf8mb4 YES utf8mb4 YES utf8mb4 NO YES www YES YES NO utf8mb4 utf8mb4 select,insert,update, references select,insert,update,references select,insert,update,references select,insert,update,references select,insert,update,references select.insert.update,references select,insert,update,references select,insert,update,references select,insert,update,references utf8mb4_0900_... select,insert,update,references select,insert,update,references select,insert,update,references select,insert,update,references select,insert,update,references select,insert,update,references select,insert,update,references utf8mb4_0900_... select,insert,update,references utf8mb4_0900_... select,insert,update,references utf8mb4_0900_... select,insert,update,references utf8mb4_0900_... select,insert,update,references utf8mb4_0900_... select,insert,update,references utf8mb4_0900_... select,insert,update,references select,insert,update,references utf8mb4_0900_... select,insert,update,references select,insert,update,references select,insert,update,references select,insert,update,references select,insert,update,references select,insert,update,references select,insert,update, references crancs utf8mb4_0900_... select,insert,update,references utf8mb4_0900_... select,insert,update,references utf8mb4_0900_... select,insert,update,references utf8mb4_0900_... select,insert,update,references utf8mb4_0900_... select,insert,update,references utf8mb4_0900_... select,insert,update,references utf8mb4_0900_... select,insert,update,references utf8mb4_0900_... select,insert,update,references utf8mb4_0900_... select,insert,update,references utf8mb4_0900_... select,insert,update,references utf8mb4_0900_... select,insert,update,references utf8mb4_0900_... select,insert,update,references utf8mb4_0900_... select,insert,update,references