So, you need help. I don't know what your question is so let's start with the beginning.
sp = stored procedure
There is a great tutorial on youtube. 9 years old but still very clear:
Then you have 2 input parameters en you must output the list you have provided.
You have several options in the WHERE clausule so you can just put it there, something like this example.
JSON is very easy to use and to create, there is some great documentation here:
Just read the documentation, try to create an sp first, create the imput parameters later, try 1 condition in the where clausule, try 2 conditions in the where clausule etc.
If you provide a working example with data and what you have created so far, I can help you getting to the next step.