Something

String query = 
					"SELECT "
						+ "avg(selling_price) as avg, "
						+ "min(selling_price) as min, " 
						+ "max(selling_price) as max, "
						+ "day" 
					+ " FROM "
						+ "("
						+ " SELECT " 
							+ "((" + ItemTable.SELLING_PRICE + " - avg ) / stddev) as Z, "
							+ ItemTable.SELLING_PRICE + ","
							+ " date(" + ItemTable.END_TIME + ") as day"
						+ " FROM " + ItemTable.TABLENAME 
								
								
								+
								" LEFT JOIN (" + ExtIDTable.TABLENAME + ") " +
								"ON (" + ItemTable.ITEM_ID + "=" + ExtIDTable.ITEM_ID + ") " +
								"LEFT JOIN (" + CategoryMappingTable.TABLENAME + ") " +
								"ON (" + ItemTable.PRIMARY_CATEGORY + "=" + CategoryMappingTable.CATEGORY_ID + ") "
								
								
								
								+ ","
								+ "("
								+ "SELECT "
									+ "stddev(" + ItemTable.SELLING_PRICE + ") as stddev, "
									+ "avg(" + ItemTable.SELLING_PRICE + ") as avg "
								+ "FROM " + ItemTable.TABLENAME
								
								+
								" LEFT JOIN (" + ExtIDTable.TABLENAME + ") " +
								"ON (" + ItemTable.ITEM_ID + "=" + ExtIDTable.ITEM_ID + ") " +
								"LEFT JOIN (" + CategoryMappingTable.TABLENAME + ") " +
								"ON (" + ItemTable.PRIMARY_CATEGORY + "=" + CategoryMappingTable.CATEGORY_ID + ") "
								
								
								
								+ " WHERE " + ItemTable.TITLE + " LIKE ? "
								
								
								
								+ ") as woot"
								
								
						+ " WHERE " + ItemTable.TITLE + " LIKE ? "
						;