using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Data.OleDb;

​

namespace PI_WORKS_final

{

    class Program

    {

        static void Main(string[] args)

        {

            OleDbConnection conn = new OleDbConnection();

​

            conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\ybalc\Desktop\Veri_Input\exhibitA-input.accdb;";

​

            conn.Open();

            OleDbCommand command = new OleDbCommand("select count(SONG_ID),CLIENT_ID from [ExhibitA-input] where PLAY_TS between DateValue('10.08.2016') and DateValue('11.08.2016') group by CLIENT_ID ;", conn);

            OleDbDataReader reader = command.ExecuteReader();

            int i = 0;

            while (reader.Read())

            {

                int a = reader.GetInt32(0);

                if (a == 346)

                {

                    i++;

                }

                else continue;

            }

            Console.WriteLine("Count of users that played 346 distinct songs: {0}", i);

            reader.Close();

​

            OleDbCommand command_MaxSongs = new OleDbCommand("select top 1 * from (select count(SONG_ID),CLIENT_ID from [ExhibitA-input] where PLAY_TS between DateValue('10.08.2016') and DateValue('11.08.2016') group by CLIENT_ID order by count(SONG_ID) desc);", conn);

            OleDbDataReader reader_max = command_MaxSongs.ExecuteReader();

            while (reader_max.Read())

            {

                Console.WriteLine("Maximum number of distinct songs played: {0}",reader_max[0]);

            }

            reader.Close();

            conn.Close();

            Console.ReadKey();

        }

    }

}

​