title: Can I create computed columns in SQLite?
body: <p>What would be the syntax (if it's possible), for example, to create a table called <code>Car_Model</code> that has a foreign key to a table <code>Car_Make</code>, and give <code>Car_Make</code> a column which is the number of <code>Car_Models</code> that exist of that <code>Car_Make</code>.</p>
  
  <p>(If this seems trivial or homework-like it's because I am just playing with some python at home trying to recreate a problem I was having at work.  We use MS-SQL at work.)</p>