尝试,
SELECt userIDFROM tableNameWHERe (questionID = 14 AND answer = 'yes' ) OR (questionID = 54 AND answer <> 'empty') OR (questionid = 100 AND answer > 10)GROUP BY userIDHAVINg COUNT(*) = 3

尝试,
SELECt userIDFROM tableNameWHERe (questionID = 14 AND answer = 'yes' ) OR (questionID = 54 AND answer <> 'empty') OR (questionid = 100 AND answer > 10)GROUP BY userIDHAVINg COUNT(*) = 3