How many professors do have a Ph.D. degree?
CREATE TABLE professor (prof_high_degree VARCHAR)
SELECT COUNT(*) FROM professor WHERE prof_high_degree = 'Ph.D.'
### Context: CREATE TABLE professor (prof_high_degree VARCHAR) ### Question: How many professors do have a Ph.D. degree? ### Answer: SELECT COUNT(*) FROM professor WHERE prof_high_degree = 'Ph.D.'