SQL Stored

Question

I have to write a script "storedprodure.sql" that contains the code for creating a stored produre 'stats_cliente' that takes a client id as argument and shows statics for contracting customer services in the organization, as show in Anexo II.

The anexo II have this:
CALL stats_cliente(12)

Someone know how to do this?

Answer 1

sneeze
I need to create new names or if i just select all i want to show isnt the same? I dont really understand this last part of the class

Answer 2

Is this an assignment in sololearn or a school assignment ?
As I read it.

You need to write a script.
That creates a stored procedure.
The stored procedure should show the statistics of a client as shown in Anexo II.
The client ID is a input parameter of your stored procedure.

I don't known, what is shown in Anexo II.

Answer 3

Its a college assignment,

Thank you for the help sneeze

Answer 4

What is it you do not understand.

Show us your attempt first.

https://www.w3schools.com/sql/sql_stored_procedures.asp