Question

Conditional where

  • 15 September 2021
  • 0 replies
  • 5 views

Hello, im having trouble with my code in the 6th line. I already tried “BETWEEN 0 AND 5000” and this. Does someone know what would be a correct way ?

 

SELECT 
date_trunc(date, month) as Month,
AVG(credit_card_account__limit_range_max) as Credit_Limit

FROM core.credit_card_account_daily_snapshot

WHERE credit_card_account__limit_range_max (0, 5000)

GROUP BY Month, account__id
ORDER BY Month


0 replies

Be the first to reply!

Reply