Question

Write SQL query to create a table 'Player' with the following structure :

| Field | Type | Constraint |
| playerid | Integer | Primary Key |
| name | Varchar (50) | |
| height | Integer | |
| weight | Integer | |
| datebirth | Date | |
| teamname | Varchar (50) | |

Answer 1

CREATE TABLE Player(playerld integer PRIMARY KEY name varchar( S0), height integer, weight integer, datebirth date, teamname varchar(50));