Aggregate functions: sum(), count(), avg(), max(), min()

Can someone help with the SQL Statement based on their respective query? I did some, but they appear to have a parameter, which I am not too certain. Thank you

LIKE operator can be combined with wildcard symbols: SQL 92 Standard (SQL Server, MySQL, etc.)-- exactly one character, %-anyset of one or more DOSexactly one character;any set of one or more characters haracters Microsoft Access (based on MS 19 List all visits in which reason/diagnosis starts with 20 st all visits in which reason/diagnosis has monitoring 21 diabetes in it. List all invoices for invoice items that have b as the third letter from the left. 22List all patients where emails are missing 23 List all patients where emails are not missing