title: how do I query SQLite database with two conditions?
body: <p>I have a table about employee with 3 columns like following code:</p>
  
  <pre><code> db.execSQL("CREATE TABLE " + TABLE_NAME + " (" + _ID
                  + " INTEGER PRIMARY KEY AUTOINCREMENT, " + DEPT
                  + " TEXT NOT NULL," + NAME + " TEXT NOT NULL," + CITY + " TEXT NOT NULL);");
  </code></pre>
  
  <p>now I just want to show employees in the same both DEPT and CITY(e.i both employees in HCM City and Sales department). How can I query to get it?</p>