-- Language PostgreSQL
        -- Tables: 
             -- Table: player attributes 
columns : [['id', 'number'], ['player fifa api id', 'number'], ['player api id', 'number'], ['date', 'text'], ['overall rating', 'number'], ['potential', 'number'], ['preferred foot', 'text'], ['attacking work rate', 'text'], ['defensive work rate', 'text'], ['crossing', 'number'], ['finishing', 'number'], ['heading accuracy', 'number'], ['short passing', 'number'], ['volleys', 'number'], ['dribbling', 'number'], ['curve', 'number'], ['free kick accuracy', 'number'], ['long passing', 'number'], ['ball control', 'number'], ['acceleration', 'number'], ['sprint speed', 'number'], ['agility', 'number'], ['reactions', 'number'], ['balance', 'number'], ['shot power', 'number'], ['jumping', 'number'], ['stamina', 'number'], ['strength', 'number'], ['long shots', 'number'], ['aggression', 'number'], ['interceptions', 'number'], ['positioning', 'number'], ['vision', 'number'], ['penalties', 'number'], ['marking', 'number'], ['standing tackle', 'number'], ['sliding tackle', 'number'], ['gk diving', 'number'], ['gk handling', 'number'], ['gk kicking', 'number'], ['gk positioning', 'number'], ['gk reflexes', 'number']]

 -- Table: sqlite sequence 
columns : [['name', 'text'], ['seq', 'text']]

 -- Table: player 
columns : [['id', 'number'], ['player api id', 'number'], ['player name', 'text'], ['player fifa api id', 'number'], ['birthday', 'text'], ['height', 'number'], ['weight', 'number']]

 -- Table: league 
columns : [['id', 'number'], ['country id', 'number'], ['name', 'text']]

 -- Table: country 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: team 
columns : [['id', 'number'], ['team api id', 'number'], ['team fifa api id', 'number'], ['team long name', 'text'], ['team short name', 'text']]

 -- Table: team attributes 
columns : [['id', 'number'], ['team fifa api id', 'number'], ['team api id', 'number'], ['date', 'text'], ['buildup play speed', 'number'], ['buildup play speed class', 'text'], ['buildup play dribbling', 'number'], ['buildup play dribbling class', 'text'], ['buildup play passing', 'number'], ['buildup play passing class', 'text'], ['buildup play positioning class', 'text'], ['chance creation passing', 'number'], ['chance creation passing class', 'text'], ['chance creation crossing', 'number'], ['chance creation crossing class', 'text'], ['chance creation shooting', 'number'], ['chance creation shooting class', 'text'], ['chance creation positioning class', 'text'], ['defence pressure', 'number'], ['defence pressure class', 'text'], ['defence aggression', 'number'], ['defence aggression class', 'text'], ['defence team width', 'number'], ['defence team width class', 'text'], ['defence defender line class', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What is the average rating for right-footed players and left-footed players?
SQL: SELECT preferred_foot ,  avg(overall_rating) FROM Player_Attributes GROUP BY preferred_foot