10. List all customers whose names begin with a letter 'C'.

SELECT
    *
FROM
    customer
WHERE
    cname LIKE 'C%';

Output: