title: Could anyone help me with these two SQL queries on my Items table?
body: <p>I made a SQL project for myself to learn.</p>
  <p>I am trying to answer these two questions:</p>
  <ol>
  <li>How many total items were sold between 1970 and 2000?</li>
  <li>What state in the US had the most items sold overall?</li>
  </ol>
  <p>I am using the databricks community edition. I am trying to teach myself how to use a big data tool. I uploaded a csv file from a dataset website. I was able to generate the table just fine. I even made a couple of SQL queries that I was able to write on my own and got results.</p>
  <p>I am having issues with these last two queries. Below is the table information, and my query for the 1st question.</p>
  <p>Table name: Items</p>
  <p>Columns:</p>
  <pre><code>datetime (Date format is 10/10/1972 19:00)
  City
  state
  country
  item
  </code></pre>
  <p>My effort for the first question (How many total items were sold between 1970 and 2000?) that isn't working and gets errors:</p>
  <pre><code>SELECT COUNT(*)
  FROM [Items]
  WHERE Date BETWEEN '01-01-1970' AND '12-31-2000`
  </code></pre>
  <blockquote>
  <p>Error in SQL statement: ParseException: mismatched input '[' expecting
  {, ';'}(line 2, pos 5) == SQL == SELECT COUNT(*) FROM [items]
  -----^^^ WHERE Date BETWEEN '01-01-1970' AND '12-31-2000`</p>
  </blockquote>
  <p>What am I doing wrong? Also, I am not sure how to even begin the second question SQL query.</p>