A table named "Player" contains details about every player belonging to a sporting club. It contains 4 fields - PlayerID, GivenName, FamilyName and Phone. PlayerID is a number that is auto-generated by the DBMS.
Question 1: Write the T-SQL statement that would insert 2 records into the table Player, assuming that none of the fields can be left "NULL".
Question 2: Write the T-SQL statement that would display all players that have a PlayerID greater than or equal to 1000
Question 3: Write the T-SQL statement that would delete all players named "Smith" from the Player table.