Database schema:

CREATE TABLE "Answer" (
	"AnswerText" TEXT -- example: ['44', '37'],
	"SurveyID" INTEGER -- example: ['2014', '2016'],
	"UserID" INTEGER -- example: ['2', '1'],
	"QuestionID" INTEGER -- example: ['2', '1'],
	PRIMARY KEY ("UserID", "QuestionID"), 
	CONSTRAINT fk_answer_question FOREIGN KEY("QuestionID") REFERENCES "Question" (questionid),
	CONSTRAINT fk_answer_survey FOREIGN KEY("SurveyID") REFERENCES "Survey" ("SurveyID")
)


CREATE TABLE "Question" (
	questiontext TEXT -- example: ['What is your age?', 'What is your gender?'],
	questionid INTEGER -- example: ['2', '1'],
	PRIMARY KEY (questionid)
)


CREATE TABLE "Survey" (
	"SurveyID" INTEGER -- example: ['2014', '2016'],
	"Description" TEXT -- example: ['mental health survey for 2014', 'mental health survey for 2016'],
	PRIMARY KEY ("SurveyID")
)

Question: How many female users were surveyed in the mental health survey for 2017 in the state of Nebraska?
Evidence: AnswerText = 'Yes' where questiontext = 'Do you have a family history of mental illness?'; AnswerText = 'Female' where questionid = 2; AnswerText = 'Nebraska' where questionid = 4

SQL:
SELECT COUNT(*) FROM ( SELECT T2.UserID FROM Question AS T1 INNER JOIN Answer AS T2 ON T1.questionid = T2.QuestionID INNER JOIN Survey AS T3 ON T2.SurveyID = T3.SurveyID WHERE T3.Description = 'mental health survey for 2017' AND T1.questionid = 2 AND T2.AnswerText = 'Female' UNION SELECT T2.UserID FROM Question AS T1 INNER JOIN Answer AS T2 ON T1.questionid = T2.QuestionID INNER JOIN Survey AS T3 ON T2.SurveyID = T3.SurveyID WHERE T1.questionid = 4 AND T2.AnswerText = 'Nebraska' AND T3.Description = 'mental health survey for 2017' )