I have written code in T-Sql used code converter for PostgreSQL, got below code but it is giving complier error. I have no clue in PostgreSQL so any pointer will be of great help.
------------------------------------------------------------------------------------------------------------------------------
Code:
select t.team_id, t.team_name,COALESCE(SUM(num_points),0) num_points from (select team_id, [B]host_team,[/]