title: Sqlite REFERENCES keyword
body: <p>Does anyone know what the REFERENCES keyword does in sqlite? For example if I had the following statement: <code>fr int REFERENCES contacts(id)</code> what does that mean and how do I use it if I wanted to <code>SELECT count(fr) from TABLE WHERE</code> I know a contact's id?</p>
  
  <p>In other words I want to create a <code>SELECT</code> statement that counts the number of <code>fr</code> where the contact id is equal to some number.</p>