Need Help Writing Query for Search...

Hi,

I am trying to finish up a project, and I am not the proficient yet in SQL. I need to know what queries I would write to do multiple searches for the attached search box.

Any help is greatly appreciated.

Thanks in advance.