Creating a stored procedure in SQL with example

A stored procedure is a group of SQL statements compiled into one unit for later use and can be used many times.