title: SQL(Snowflake) - SUMIFS but condition is set per that row in multiple column conditions
body: <p>I have a table</p>
  
  <pre><code>|---------------------|------------------|-----------|
  |      Live-Date      |     Live_Cohort  | Unit_Count| Desired_Output (Weighting of Unit Count)
  |---------------------|------------------|-----------|
  |         3/1/19             Q1 2019            5          56%
            3/1/19             Q1 2019            4          44%
            4/1/19             Q1 2019            3          100%
            4/1/19             Q2 2019            4          29%
            4/1/19             Q2 2019            10         71%
  
  </code></pre>
  
  <p>How do I write a query that acts as a sumifs function in excel that counts the weighting of the unit count in each row with the total unit count that matches the live_date and live_cohort in that row. </p>
  
  <p>For example in row 1, 5 units accounts for 56% of the total units in the live date of 3/1/19 and Q1/2019 and do that for every row as shown in the desired_output column </p>