//Write a SQL query to find the full name, salary and department of the employees that take the minimal salary in their department.
         void Query24()
            {
                var context = new TelerikAcademyContext();
                var salarySearch = context.Employees
                    .Include(e => e.Department)
                    .Select(g => new
                    {
                        g.FirstName,
                        g.LastName,
                        g.DepartmentId,
                        g.Salary

                    }
                    ).GroupBy(h => h.DepartmentId)
                    .Select(e => new
                    {
                        ID = e.Key,
                        Min = e.Min(t => t.Salary)

                    }
                    ).ToList();
                int r = 1;
                foreach (var y in salarySearch)
                {
                    var result = context.Employees
                        .Include(e => e.Department)
                        .Where(e => e.DepartmentId == r && e.Salary == y.Min)
                        .Select(h => new
                        {
                            h.FirstName,
                            h.LastName,
                            h.Salary,
                            h.Department.Name,
                            h.DepartmentId
                        }
                        ).ToList();
                    r++;
                    foreach (var help in result)
                    {
                        Console.WriteLine($"department ID: {help.DepartmentId} {help.FirstName} {help.LastName} {help.Name} {help.Salary}");

                    }
                }


            }