-- write a sql statement to insert the indicated data into the employee table 
-- auto_increment is a feature in SQL that automatically generates a unique number for a column whenever a new row is inserted. 
-- Most commonlly used for primary keys, ID, or Employee ID

CREATE TABLE Employee( 
    EmployeeID INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    FirstName VARCHAR(255), 
    LastName VARCHAR(255), 
    Salary DECIMAL(10,2), 
-- 10 total number of digts 
-- 2 number of digits after the decimal point(scale)
    ManagerID INT
    
); 

INSERT INTO Employee ( 
    FirstName, 
    LastName, 
    Salary, 
    ManagerID
) VALUES ( 
    'Robert', 
    'Brown',
    150000.50, 
    NULL
);

SELECT* 
FROM Employee