title: count entries in database
body: <p>I am new to sqlite for iOS. I am making an app in which user will store the client names in the database according to the day they're appointed.</p>
  
  <pre><code>id Day         Client1    Client2    Client3    Client4    Client5    Client6
  0  Monday      Nitin      Vijay      Akshay     Ajit       Sahil      Ravi
  1  Tuesday     Ravi       Akshay     Nitin      Sahil      Vijay      Ajit    
  2  Wednesday   Vijay      Nitin      Vijay      Akshay     Ravi       Ajit
  3  Thursday    Akshay     Ajit       Nitin      Ravi       Sahil      Vijay
  4  Friday      Nitin      Nitin      Akshay     Sahil      Ravi       Vijay
  </code></pre>
  
  <p>Some clients will be repeated daily, how to count number of times each client has met me and save it to int every day.</p>
  
  <p>eg.</p>
  
  <pre><code>Monday
  Nitin = 1
  Vijay = 1
  Akshay = 1
  Ajit = 1
  Sahil = 1
  Ravi = 1
  </code></pre>
  
  <p>This should be updated daily at 12:00AM and if I request database to show the count on Tuesday, it should come with (Count on Monday + Count on Tuesday)</p>
  
  <pre><code>Tuesday
  Nitin = 2
  Vijay = 2
  Akshay = 2
  Ajit = 2
  Sahil = 2
  Ravi = 2
  </code></pre>
  
  <p>How should I achieve it?</p>