title: Counting Organizations by using Python and Sqlite
body: <p>This application will read the mailbox data (mbox.txt) count up the number email messages per organization (i.e. domain name of the email address) using a database with the following schema to maintain the counts.</p>
  
  <pre><code>CREATE TABLE Counts (org TEXT, count INTEGER)
  </code></pre>
  
  <p>When you have run the program on mbox.txt upload the resulting database file above for grading.
  If you run the program multiple times in testing or with different files, make sure to empty out the data before each run.</p>
  
  <p>You can use this code as a starting point for your application: <a href="http://www.pythonlearn.com/code/emaildb.py" rel="nofollow">http://www.pythonlearn.com/code/emaildb.py</a>. The data file for this application is the same as in previous assignments: <a href="http://www.pythonlearn.com/code/mbox.txt" rel="nofollow">http://www.pythonlearn.com/code/mbox.txt</a>.</p>
  
  <p>First time to learn Sqlite. I am very confused about this assignment although it seems to be easy. I don't know how can I connect Python codes to Sqlite. It seems that they don't need the code as assignment. All the need is database file. How should I solve this problem. Don't know how to start it. Much appreciated it!</p>