mysql - Returning null values in mysqli query -

i trying run mysqli query calculates how many times team has scored final score (total). can enough, want return null values. need return below. don't final score '13' displaying.

eg

table : matchdetails        total  | occurances         10    | 1         11    | 3         12    | 4         13    | 0         14    | 3    select total, count(total) occurrences matchdetails  team = '$team' group total 

managed sort out. created separate table possible final scores in , left out joined 2 tables.

select dataset1.team, dataset1.occurrences, s1.finalscores scoreslist s1 left outer join (select team, count(total) occurrences, total matchdetails team = '$team' group total) dataset1 on dataset1.total=s1.finalscores