Consider a "CUSTOMERS" database table having a column "CITY" filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that have "GAR" somewhere in its name, is:
A. select * from customers where city='%GAR%';
B. select * from customers where city='$GAR$';
C. select * from customers where city like '%GAR%';
D. select * from customers where city as'%GAR';