Drupal View query for select fields produces different results that CiviCRM
If you haven't upgraded Civi to 5.28.4 than apply below patch
https://patch-diff.githubusercontent.com/raw/civicrm/civicrm-drupal/pull/617.patch
https://patch-diff.githubusercontent.com/raw/civicrm/civicrm-drupal/pull/618.patch