# SQL 9. Variables

**URL:** <https://forum.codewithmosh.com/t/sql-9-variables/24952>\
**Category:** SQL\
**Created:** [February 7, 2024, 5:53am UTC](https://forum.codewithmosh.com/t/sql-9-variables/24952 "2024-02-07T05:53:35Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ritu](https://avatars.discourse-cdn.com/v4/letter/r/7993a0/32.png) [@Ritu](https://forum.codewithmosh.com/u/Ritu)\
**Post date:** [February 7, 2024, 5:53am UTC](https://forum.codewithmosh.com/t/sql-9-variables/24952/1 "2024-02-07T05:53:35Z")

</div>

– – Local variables  
DELIMITER $$  
CREATE PROCEDURE Get\_Risk\_Factor()  
BEGIN

# Risk\_Factor = Invoices\_Total/Invoices\_Count \* 5

DECLARE Risk\_Factor DECIMAL (9, 2) DEFAULT 0;  
DECLARE **Invoices\_Total DECIMAL (9, 2);**  
DECLARE **Invoices\_Count INT;**

SELECT  
COUNT(\*),  
SUM(Invoice\_Total)  
INTO **Invoices\_Count, Invoices\_Total**  
FROM Invoices;

SET Risk\_Factor = ( **Invoices\_Total** / **Invoices\_Count** ) \* 5;  
SELECT Risk\_Factor;  
END$$  
DELIMITER ;

call part2\_invoicing.Get\_Risk\_Factor();  
Returns 777.75 !