namespace LINQExample

{

    public class Movie

    {

        #region Constructors

        public Movie (string title, int year, string director, string language, double rating)

        {

            Title = title;

            Year = year;

            Director = director; 

            Language = language;

            Rating = rating;

        }

        #endregion

​

        #region Properties

        public string Title { get; set; }

        public int Year { get; set; }

        public string Director { get; set; }

        public string Language { get; set; }

        public double Rating { get; set; }

        #endregion

    }

​

internal class Program

    {

        static void Main(string[] args)

        {

            var movies = new List<Movie>();

​

            movies.Add(new Movie("The 400 Blows", 1959, "Truffaut", "French", 4.3));

            movies.Add(new Movie("La Haine", 1995, "Kassovitz", "French", 4.5));

            movies.Add(new Movie("Jean de Florette", 1986, "Berri", "French", 4.0));

            movies.Add(new Movie("City of Lost Children", 1995, "Jeunet and Caro", "French", 3.7));

            movies.Add(new Movie("Parasite", 2019, "Bong", "Korean", 4.6));

            movies.Add(new Movie("The Housemaid", 1960, "Kim", "Korean", 3.8));

            movies.Add(new Movie("Aimless Bullet", 1961, "Yu", "Korean", 3.8));

            movies.Add(new Movie("Solaris", 1972, "Tarkovsky", "Russian", 4.2));

            movies.Add(new Movie("Stalker", 1979, "Tarkovsky", "Russian", 4.4));

​

            var countFrenchMovies = movies.Count(movie => movie.Language == "French");

            Console.WriteLine($"The number of French movies in the list is: {countFrenchMovies}");

​

            var countKoreanMovies = movies.Count(movie => movie.Language == "Korean");

            Console.WriteLine($"The number of Korean movies in the list is: {countKoreanMovies}");

​

            var countRussianMovies = movies.Count(movie => movie.Language == "Russian");

            Console.WriteLine($"The number of Russian movies in the list is: {countRussianMovies}");

​

            var moviesFrom60s = movies.Where(movie => movie.Year >= 1960 && movie.Year < 1970);

            Console.WriteLine($"The movies from the 60's in the list include: {moviesFrom60s}");

​

            var moviesFrom70s = movies.Where(movie => movie.Year >= 1970 && movie.Year < 1980);

            var moviesFrom80s = movies.Where(movie => movie.Year >= 1980 && movie.Year < 1990);

            var moviesFrom90s = movies.Where(movie => movie.Year >= 1990 && movie.Year < 2000);

​

            var moviesWithRatingsHigherThan4 = movies.Where(movie => movie.Rating >= 4.0);

​

            var moviesOrderedByRating = movies.OrderByDescending(movie => movie.Rating);

​

        }

    }

}