Advanced Analytics - Widgets -SQL advice

[JoanneG]

Good Afternoon

I am trying to create a widget to query requests logged today, which may contain a word in either summary or description i.e. COVID.  To allow us to view how many requests have been logged today related to covid...  

 

Please can anyone advise me on what i will need to add to this query?

 

Many thanks

 

Joanne 

[JoanneG]

Resolved Now... Thank you