SQL code needed to execute in pgAdmin and create tables with specified constraints.

6. You are given requirements for a database schema of the National Football League (NFL) as follows: -the NFL' has many teams. . each 'team, has a "name", a city', a coach, a 'captain', and a set of players, each player has a name', a position' (such as quarterback, wingback, etc), a 'skill' level, and a set of injury records (injury records have a 'description' and 'id'), . each player belongs to only one team a team captain is also a player, . a 'game' is played between two teams (referred to as host team and guest team) and has a 'game date, (such as Aug 3rd, 2010) and a score' (such as 4 to 2) Create a SQL database schema for NFL. Your schema must include all primary, foreign key requirements, and constraints defined in the description. The words in quotes correspond to table or attribute names. Do not use any other names to declare these tables or attributes. You may include new attribute names to create relationships between tables, but the attributes mentioned in the requirements must be declared as specified in quotes