title: How do I combine multiple values in an AND OR statement in Postgresql
body: <p>I am using the following script in a call to my database:</p>
  
  <pre><code>SELECT 
   1.0*(COUNT(*) FILTER(WHERE "stitch_jira"."issues"."fields__status__statusCategory__name"='Done'
   AND "stitch_jira"."issues"."fields__project__key"='FLUM'
   AND "stitch_jira"."issues"."fields__issuetype__name"='Task'
   OR "stitch_jira"."issues"."fields__issuetype__name"='Story'))/
   (COUNT(*) FILTER(WHERE "stitch_jira"."issues"."fields__status__statusCategory__name" IN('To Do','In Progress','Done')
   AND "stitch_jira"."issues"."fields__project__key"='FLUM'
   AND "stitch_jira"."issues"."fields__issuetype__name"='Task'
   OR "stitch_jira"."issues"."fields__issuetype__name"='Story'))
  FROM "stitch_jira"."issues"
  </code></pre>
  
  <p>Basically, It should be getting TASKS and STORIES that are DONE, then dividing them by the total number of tasks and stories. The results don't see to demonstrate this. IT works fine if I only do Tasks, or only do stories, but not when I do both. </p>
  
  <p>Where have I gone wrong?</p>