Retrieve same column twice with different conditions
<p>This question is already answered multiple times but I just can't get it to works. I tied use some answer from <a href="https://stackoverflow.com/questions/16423883/how-to-retrieve-same-column-twice-with-different-conditions-in-same-table">this</a> question but I always "get error more than one row returned by a subquery used as an expression"</p>

<p>I have following sql query:</p>

<pre><code>SELECT DISTINCT p.name, pma.time AS  goal, pma.time AS assist 

FROM player p

INNER JOIN player_match pm
ON p.player_id = pm.player_id

INNER JOIN matches m
ON m.match_id = pm.match_id

INNER JOIN team_match tm
ON tm.team_id = p.team_id 

FULL JOIN player_match_activity pma
ON pma.player_id = p.player_id
AND pma.activity_id = '1'
AND pma.match_id = m.match_id

WHERE m.match_id = '163'
AND tm.home_away = 'home'
</code></pre>

<p>The query gives me following result:</p>

<pre><code> name    |    goal    |    assist
-------------------------------------
Ronaldo         1            1
Messi           3            3
Vardy  
</code></pre>

<p>The column "assist" show same values like the column "goal". 
Line pma.activity_id = '1' select just goals. </p>

<p>How can I set that the column "assist" use exact same conditions like the column "goal" BUT instead of  pma.activity_id = '1' I want to change it to '2" ?</p>