title: SQL lateral view
body: <p>How can I use <strong>lateral view</strong> in SQL to extract values from JSON strings?</p>
  
  <p>Example data in table "people":</p>
  
  <pre><code>name   information
  -----  -----------------------
  Jen    {"age": 15, "gender":2}
  John   {"age": 22, "gender":1}
  Jack   {"age": 25, "gender":1}
  Pat    {"age": 55, "gender":3}
  </code></pre>