Correct me if I am wrong but SQL procedural language doesn't have support
for variable declarations?

And

Why does my stored function returns only the first row of the query instead
of the whole set of query?

Kindly educate me