If we can execute multiple sql statements inside a stored procedure. What will be the result of this stored procedure ?

create procedure usp_test
as
begin
select * from order_table
select * from product_table
end