class_docstr: Store information on generated alerts.
docstr: Create a SQL query to get the alert counts for staged rules
  
  Args:
      stats (list[StagingStatistic])
  
  Returns:
      list: SQL statement for counting alerts created by staged rules
docstr_tok: ["Create","a","SQL","query","to","get","the","alert","counts","for","staged","rules","Args",":","stats","(","list","[","StagingStatistic","]",")","Returns",":","list",":","SQL","statement","for","counting","alerts","created","by","staged","rules"]
code: def construct_compound_count_query(cls, stats):
      """Create a SQL query to get the alert counts for staged rules
  
      Args:
          stats (list[StagingStatistic])
  
      Returns:
          list: SQL statement for counting alerts created by staged rules
      """
      where_clause = " OR ".join(
          stat.sql_where_fragment for stat in stats
      )
      return cls._COUNT_QUERY_TEMPLATE.format(where_clause=where_clause)
  
file_path: streamalert/streamalert/rule_promotion/statistic.py
label_desc: Use image node_id 4 for calling the StagingStatistic obj's underlying member method code with example usage: obj.construct_compound_count_query(cls, stats) and returns: cls