# More than 1000€ in cross orders in IT or Book category :
SELECT @count {} FROM UserPoint
WHERE activity_events @ScoreSum(min : 1000) {
order_products @ScoreField(name:"price") @ScoreSum(result:"score_value") {
SELECT @count {} FROM UserPoint
WHERE activity_events @ScoreSum(min : 1000) {
order_products @ScoreField(name:"price") @ScoreSum(result:"score_value") {
order_products @ScoreField(name:"price") @ScoreSum(result:"score_value") {
# More than 1000€ in cross orders in only with product of IT or Book category :
# maximum of separately IT products and Book products is superior to 1000€
SELECT @count {} FROM UserPoint
WHERE activity_events @ScoreSum(min : 1000) {
order_products @ScoreField(name:"price") @ScoreSum(result:"score_value") {
OR order_products @ScoreField(name:"price") @ScoreSum(result:"score_value") {
# More than 1000€ in cross orders of products in IT catory and products in Book category :
SELECT @count {} FROM UserPoint
WHERE activity_events @ScoreSum(min : 1000) {
order_products @ScoreField(name:"price") @ScoreSum(result:"score_value") {
# More than 1000€ in cross orders in IT and Book category :
SELECT @count {} FROM UserPoint
WHERE activity_events @ScoreSum(min : 1000) {
order_products @ScoreField(name:"price") @ScoreSum(result:"score_value") {
AND activity_events @ScoreSum(min : 1000) {
order_products @ScoreField(name:"price") @ScoreSum(result:"score_value") {
# More than 1000€ in cross orders with at least 10 IT products and 10 BOOK products :
SELECT @count {} FROM UserPoint
WHERE activity_events @ScoreSum(min : 1000) {
order_products @ScoreField(name: "amount") @ScoreSum(){
AND order_products @ScoreSum(min: 10) {
AND order_products @ScoreSum(min: 10) {
### DUPLICATE WITH PREVIOUS QUERY
# More than 1000€ in cross orders in IT or Book category with at least 10€ of each in each order:
SELECT @count {} FROM UserPoint
WHERE activity_events @ScoreSum(min : 1000) {
order_products @ScoreField(name: "amount") @ScoreSum(){
AND order_products @Scorefield(name: "amount") @ScoreSum(min: 10) {
AND order_products @Scorefield(name: "amount") @ScoreSum(min: 10) {