title: How to merge another select query in union
body: <p>I have two queries in first query count output show base on product wise</p>
  
  <pre><code>select 'Retail' as product  ,count(1) as policy_count  from g_hdfclms where lead_status in('rtp','qc_pr') and lead_id_lms not like ('%_01')
  union
  select 'Group' As [Group],count(1) as grp_policy from g_proposal_m where lead_status in('rtp','qc_pr')
  union
  select 'Renewal' As Renewal, count (1) as policy_renewal  from g_hdfclms where lead_status in('rtp','qc_pr') and lead_id_lms like ('%_01')
  </code></pre>
  
  <p>while another query is that output is merge and show total count of every product </p>
  
  <pre><code> select(select count(*) as retail_policy from g_hdfclms where lead_status in('rtp','qc_pr') and lead_id_lms not like ('%_01'))
  +(select count(1) as grp_policy from g_proposal_m where lead_status in('rtp','qc_pr'))
  +(select count (*) as policy_renewal  from g_hdfclms where lead_status in('rtp','qc_pr') and lead_id_lms like '%_01')
  AS total_policy
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/LaJNs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LaJNs.png" alt="enter image description here"></a>
  <strong>Now i want to show Total_policy count and product wise count in same query im tried various method but fail to execute</strong></p>