Skip to content

Instantly share code, notes, and snippets.

@jezinka
Created Jul 12, 2017
Embed
What would you like to do?
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