18. Functions.sql

use ecom;
-- FUNCTIONS

-- Functions are basically the transformations. ie, what if we want to do something that is not available in sql, but we know the custom logic for it.
-- Then we can create our own function similar to UPPPER, AVG etc.
-- We can think functions like customized transformations.

-- Defenition: Functions in MySQL are predefined or user-defined routines that perform operations on data and reurrn a single value. They are very useful for manipulating data, performing calculations and symplifying queries.

delimiter //
create function square_it(x int)
returns int
deterministic
begin
	return x*x;
end //
delimiter ;

select 
	unit_price,
    square_it(unit_price)
from
	dim_product;