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

namespace LotteryNumbers
{
    class Program
    {
        static void Main(string[] args)
        {
            int[] lotteryNumbers = { 13, 45, 28, 57, 92, 31 };

            OutputAllNumbers(lotteryNumbers);
            OutputNumbersInOrder(lotteryNumbers);
            OutputSquares(lotteryNumbers);
            OutputOddNumbers(lotteryNumbers);
            OutputSumAvgMinMax(lotteryNumbers);
            Console.ReadLine();
        }

        private static void OutputAllNumbers(int[] nums)
        {
            var query = (from i in nums select i);

            Console.WriteLine("All numbers:");
            foreach (var i in query)
            {
                Console.WriteLine(i);
            }
        }

        private static void OutputNumbersInOrder(int[] nums)
        {
            var ascQuery = (from i in nums orderby i select i);
            var descQuery = (from i in nums orderby i descending select i);

            Console.WriteLine("\nNumbers in ascending order:");
            foreach (var i in ascQuery)
            {
                Console.WriteLine(i);
            }

            Console.WriteLine("\nNumbers in descending order:");
            foreach (var i in descQuery)
            {
                Console.WriteLine(i);
            }
        }

        private static void OutputSquares(int[] nums)
        {
            var sqQuery = (from i in nums select i * i);

            Console.WriteLine("\nSquares:");
            foreach (var i in sqQuery)
            {
                Console.WriteLine(i);
            }
        }

        private static void OutputOddNumbers(int[] nums)
        {
            var oddQuery = (from i in nums where i % 2 != 0 select i);

            Console.WriteLine("\nOdd numbers:");
            foreach (var i in oddQuery)
            {
                Console.WriteLine(i);
            }
        }

        private static void OutputSumAvgMinMax(int[] nums)
        {
            var sumQuery = (from i in nums select i).Sum();
            var avgQuery = (from i in nums select i).Average();
            var minQuery = (from i in nums select i).Min();
            var maxQuery = (from i in nums select i).Max();

            Console.WriteLine("\nSum: {0}", sumQuery);
            Console.WriteLine("Avg: {0}", avgQuery);
            Console.WriteLine("Min: {0}", minQuery);
            Console.WriteLine("Max: {0}", maxQuery);
        }
    }
}