Check the table in cmd:

If-elseif-else:

Loops:

Simple_loop static:

Simple loop dynamic:

Stored procedure without parameter:

Stored procedure with parameter:

Local and Session variables:

Local parameter:

Simple procedure practice: