Search product in e-commerce website

1

Hi goodmorning.
I want to search Product by multiple check CATEGORY, multiple check BRAND, multiple select color, multple select price ,,,

How to make a proc in sql server???

Plz help me sir.

2

Can you please provide sample data?