使用C# Linq，请尝试以下操作：

var test =  context.stats.GroupBy(x=> x.Email).Select(groupedBy=> new {
            Email = groupedBy.FirstOrDefault().Email,
            Opened = groupedBy.Where(y=> y.Status == "opened").Count(),
            Clicked = groupedBy.Where(y=> y.Status == "clicked").Count()
        });

您需要一个数据透视表。请参见下面的代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;

namespace ConsoleApplication40
{
    class Program
    {

        static void Main(string[] args)
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("Email", typeof(string));
            dt.Columns.Add("Status", typeof(string));

            dt.Rows.Add(new object[] { "email1", "opened"});
            dt.Rows.Add(new object[] { "email1", "opened" });
            dt.Rows.Add(new object[] { "email2", "clicked" });
            dt.Rows.Add(new object[] { "email2", "clicked" });
            dt.Rows.Add(new object[] { "email2", "clicked" });
            dt.Rows.Add(new object[] { "email1", "clicked" });
            dt.Rows.Add(new object[] { "email2", "opened" });

            string[] statusTypes = dt.AsEnumerable().Select(x => x.Field<string>("Status")).Distinct().OrderBy(x => x).ToArray();
            var groups = dt.AsEnumerable().GroupBy(x => x.Field<string>("Email")).ToList();

            DataTable pivot = new DataTable();
            pivot.Columns.Add("Email",typeof(string));
            foreach(string statusType in statusTypes)
            {
                pivot.Columns.Add(statusType, typeof(int));
            }

            foreach(var group in groups)
            {
                DataRow row = pivot.Rows.Add();
                row["Email"] = group.Key;
                foreach(string statusType in statusTypes)
                {
                    row[statusType] = group.Where(x => x.Field<string>("Status") == statusType).Count();
                }
            }
        }
    }
}