-- Database schema
| divisions : division [ TEXT ] primary_key , name [ TEXT ] , country [ TEXT ] | matchs : Div [ TEXT ] matchs.Div = divisions.division , Date [ DATE ] , HomeTeam [ TEXT ] , AwayTeam [ TEXT ] , FTHG [ INTEGER ] , FTAG [ INTEGER ] , FTR [ TEXT ] , season [ INTEGER ] |
-- -- How many teams playing in divisions in Greece have ever scored 4 or more goals?

SELECT COUNT(DISTINCT CASE WHEN T1.FTHG >= 4 THEN HomeTeam ELSE NULL end) + COUNT(DISTINCT CASE WHEN T1.FTAG >= 4 THEN AwayTeam ELSE NULL end) FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T2.country = 'Greece' ;