SQLize | PHPize | SQLtest

CREATE TABLE gaming_products ( product_id INT AUTO_INCREMENT PRIMARY KEY, product_name VARCHAR(100), price DECIMAL(10,2), discount DECIMAL(5,2), quantity INT ); INSERT INTO gaming_products (product_name, price, discount, quantity) VALUES ('Power Armor', 5500, 0.35, 80), ('Energy Sword', 10000, 0.20, 15), ('Exo Suit', 52500, 0.25, 65), ('Plasma Rifle', 12000, 0.30, 75), ('Virtual Reality Headset', 4500, 0.50, 65); -- Create function get_discount DELIMITER $$ CREATE FUNCTION get_discount(gaming_price DECIMAL(10,2), gaming_discount DECIMAL(10,2), gaming_product VARCHAR(50)) RETURNS VARCHAR(50) BEGIN DECLARE computation DECIMAL(10,2) DEFAULT gaming_price * gaming_discount; DECLARE final_price DECIMAL(10,2) DEFAULT gaming_price - computation; RETURN CONCAT(gaming_product ,' discounted price: $', CAST(final_price AS CHAR)); END$$ DELIMITER ; SELECT get_discount(price, discount, product_name) AS discounted_price FROM gaming_products; -- Create function calculate_selling_price DELIMITER $$ CREATE FUNCTION calculate_selling_price(gaming_price DECIMAL(10,2), gaming_product VARCHAR(50), markup DECIMAL(10,2)) RETURNS VARCHAR(50) BEGIN DECLARE computation DECIMAL(10,2) DEFAULT gaming_price * markup; DECLARE final_price DECIMAL(10,2) DEFAULT computation + gaming_price; RETURN CONCAT(gaming_product ,' selling price: $', CAST(final_price AS CHAR)); END$$ DELIMITER ; SELECT calculate_selling_price(price, product_name, .20) AS selling_price FROM gaming_products;