Skip to content

Instantly share code, notes, and snippets.

@jezinka

jezinka/DinnerContract.java Secret

Created July 12, 2017 08:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jezinka/86acf8662de27f3de90a5300517ebc84 to your computer and use it in GitHub Desktop.
Save jezinka/86acf8662de27f3de90a5300517ebc84 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
DinnerContract.java
private String getCountDinnersQuery() {
String mealName = MealContract.columnName;
return "select " + mealName + ", count(" + mealName + ") as quantity from " + tableName
+ " join " + MealContract.tableName
+ " on " + tableName + "." + columnMealId + " = " + MealContract.tableName + "." + _ID
+ " group by " + mealName
+ " order by 2";
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment