Schema: CREATE TABLE projects (name VARCHAR)
Question: Find the number of distinct projects.
SQL: SELECT COUNT(DISTINCT name) FROM projects