My first GIST PostgreSQL Practice

Roster.SQL

SELECT * FROM employees  
SELECT * FROM employees where salary > 10000000 and is_starter = true
SELECT * FROM employees where position = 'Goalkeeper'
SELECT * FROM employees where jersey_number = 10
SELECT full_name, jersey_number from employees where is_starter = true

*Added a new player (Coutinho) to database and going to delete this player*
SELECT * FROM employees where full_name = 'Coutinho'
DELETE FROM employees where full_name = 'Coutinho'

*Updated two players from being a starter*
UPDATE employees SET is_starter = false where full_name = 'Jordan Henderson'
UPDATE employees SET is_starter = true where full_name = 'Alex Oxlade-Chamberlain'