SELECT count(DISTINCT name) FROM projects
How many different projects are there?
SELECT count ( DISTINCT name ) FROM projects
select count ( distinct name ) from projects
How many different projects are there ?