The way to get around this is to create inline views of your aggregates and join on the those results. SELECT R.title_id, R.revenue, R.cost, F.interest FROM (SELECT title_id, Sum(revenue) revenue,…
Help snippets on NodeJs, React, ColdFusion, PHP, Android, iOS and tech news