using System;

using System.Linq;

using System.Collections.Generic;

public static class Program

{

    public static void Main()

    {

        var joinTable = SeedJoinTable();

        var query = joinTable

            .GroupBy(jt => new { jt.StudentId, jt.LectureId } )

            .Select(g => new {

                StudentId = g.Key.StudentId,

                LectureId = g.Key.LectureId, 

                CountStudentId =  -1, // Count all StudentId (i.e. 10)?

                CountStudentIdLectureId = g.Count()

            });

        // this is just the printing of the results

        Console.WriteLine(

            "StudentId".PadRight(15) +

            "LectureId".PadRight(15) +

            "CountStudentId".PadRight(17) +

            "CountStudentLectureId".PadRight(15));

        foreach(var x in query)

        {

            Console.WriteLine(string.Format("{0}{1}{2}{3}", 

                x.StudentId.ToString().PadRight(15), 

                x.LectureId.ToString().PadRight(15), 

                x.CountStudentId.ToString().PadRight(17), 

                x.CountStudentIdLectureId.ToString().PadRight(15)));

        }

    }

    public static List<JoinTable> SeedJoinTable()

    {

        var list = new List<JoinTable>();

        var studentId = 0;

        var lectureId = 0;

        // insert 20 records

        for(int i = 0; i < 20; ++i)

        {

            if(i != 0)

            {

                if(i % 10 == 0) 

                {   

                    // 10 of each studentId

                    ++studentId;

                    lectureId = 0;

                }

                if(i % 3 == 0)

                {

                    // 3 of each lectureId per student

                    ++lectureId;

                }

            }

            list.Add(new JoinTable() { 

                StudentId = studentId, 

                LectureId = lectureId 

            });

        }

        return list;

    }

    public class JoinTable

    {

        public int StudentId { get; set; }

        public int LectureId { get; set; }

    }

}