I am writing to the coursework stored procedures for transactions, which is provided on the screen. How to write?

Question

SQL Server

1) as I understand it, you need to initially take the data from the table, which is provided on the screen: @N_pp and so on.
2) the conditions went further (multiplications and the conditions at the end). How to write such a stored procedure? I didn't write like that