-- Database schema
| Question : questiontext [ TEXT ] , questionid [ INTEGER ] primary_key | Survey : SurveyID [ INTEGER ] primary_key , Description [ TEXT ] | Answer : AnswerText [ TEXT ] , SurveyID [ INTEGER ] , UserID [ INTEGER ] , QuestionID [ INTEGER ] |
-- -- How many respondents of the mental health survey were diagnosed with 'Substance Use Disorder'?

SELECT COUNT(AnswerText) FROM Answer WHERE AnswerText LIKE 'Substance Use Disorder';