Strategy
-
History
Table
Search
Calculation
MRR
Revenue
SET @target_month = '2023-05-01';
SELECT SUM(CASE
WHEN lang = 'en' THEN amount_remaining*1200
ELSE amount_remaining
END) FROM payment WHERE amount > 0 AND (lang = 'ko' OR lang = 'en') AND start_date > @target_month AND start_date < DATE_ADD(@target_month, INTERVAL 1 MONTH)
SQL
복사
SELECT SUM(CASE
WHEN lang = 'en' THEN amount_remaining*1200
ELSE amount_remaining
END) FROM payment WHERE amount > 0 AND (lang = 'ko' OR lang = 'en')
SELECT SUM(amount_remaining) FROM payment WHERE amount > 0 AND (lang = 'ko')
SQL
복사