SALARIES — Names starting with C

Write a query that returns all the professor names that begin with the letter C.

Table schema

CREATE TABLE SALARIES (Professor_Name TEXT, Department TEXT, Salary INT);

Hint (click to show)

Use LIKE with a wildcard.

Your SQL query