title: Why is my sql script returning "[null]" and "0" values even though my table is populated?
body: <p>I have manually populated a table as follows:</p>
  <pre><code>INSERT INTO country  VALUES
  -- columns are countryid, name, continent, population, gdp, lifeexpectancy, founded
  (1, 'Argentina', 36.3, 348.2, 70.75, 9/7/1816), 
  (2, 'Brazil', 183.3, 1004, 65.6, 9/7/1822),
  (3, 'Canada', 30.1, 658, 77.08, 1/7/1867),
  (4, 'England', 60.8, 1256, 75.15, NULL),
  (5, 'France', 60, 1000, 75.15, 14/7/1789),
  (6, 'Mexico', 107.5, 694.3, 69.36, 16/9/1821),
  (7, 'USA', 270, 8003, 75.75, 4/7/1776),
  (8, 'Cuba', 11.7, 16.9, 75.95, 24/2/1895),
  (9, 'Guatemala', 20, 200, 60, 15/9/1821),
  (10, 'Tanzania', 55.57, 47.43, 60.76, 9/12/1961),
  (11, 'India', 1324, 2264, 68.35, NULL),
  (12, 'South Africa', 55.91, 294.8, 57.44, 31/05/1910),
  (13, 'Costa Rica', 4.86, 57.44, 79.59, 15/9/1821),
  (14, 'Uganda', 41.49, 25.53, 59.18, NULL);
  
  </code></pre>
  <p>but when I query</p>
  <pre><code>SELECT lifeexpectancy FROM country;
  </code></pre>
  <p>The tables returns a combination of &quot;0&quot; and &quot;[null]&quot; values.</p>
  <p>I've tried changing the data_type of lifeexpectancy. Neither text nor numeric data types return values that have been entered.</p>
  <p>Any suggestions?</p>