title: why doesn't pandas execute sql query?
body: <p>why doesn't pandas execute sql query?</p>
  
  <pre><code>import sqlite3
  import pandas as pd
  
  # load data
  df = pd.read_csv('CurriculumAuditReport.csv')
  
  # strip whitespace from headers
  df.columns = df.columns.str.strip()
  
  con = sqlite3.connect("sans.db")
  
  # drop data into database
  df.to_sql("MyTable", con, if_exists='replace')
  
  df = pd.read_sql_query('SELECT Count (Department) FROM MyTable WHERE `CompletedTraining` LIKE 'Incomplete' GROUP BY Department', con)
  print(df)
  
  
  con.close()
  </code></pre>
  
  <p>the query produces the result i want just fine in DB browser for SQLite</p>
  
  <pre><code>the output 
      C:\sans&gt;C:\python34\python test2.py
    File "test2.py", line 15
      df = pd.read_sql_query('SELECT Count (Department) FROM MyTable WHERE 
  `CompletedTraining` LIKE 'Incomplete' GROUP BY Department', con)
  
  
                                     ^
  SyntaxError: invalid syntax
  </code></pre>
  
  <p>my output should have 11 rows</p>