CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- SELECT
- (SELECT COUNT(*) FROM projects WHERE IF(currency = 'RUB', budget / 2.8, budget) <= 1000) AS g1,
- (SELECT COUNT(*) FROM projects WHERE IF(currency = 'RUB', budget / 2.8, budget) > 1000) AS g2,
- FROM projects