IN query for Elasticsearch combined with containing query

in_query_elasticsearch.json

{
  "query": {
    "bool": {
      "must": [
        {
          "query_string": {
            "fields": [ "name", "rollno" ],
            "query": "*John*"
          }
        },
        {
          "query_string": {
            "fields": [ "majorSubject" ],
            "query": "Chemistry OR Biology OR Mathematics"
          }
        }
      ]
    }
  }
}