• Creating Table

CREATE TABLE dboAccountManagers (
    EmployeeID INTEGER AUTO_INCREMENT PRIMARY KEY, 
    FirstName VARCHAR(20) NOT NULL, 
    LastName NVARCHAR(20) NULL, 
    DateOfBirth DATE NOT NULL, 
    Salary DECIMAL(10, 2) NOT NULL);

• Adding Data into Table

INSERT INTO dboAccountManagers VALUES (1, "Martin", "Ødegaard", "1994-07-26", 92000.00);

INSERT INTO dboAccountManagers VALUES (3, "Rene", "Rovers", "1994-12-06", 85000);

INSERT INTO dboAccountManagers VALUES (5, "Dannie", 8411, "1994-07-26", 75000.25);

INSERT INTO dboAccountManagers VALUES (7, "Aisha", "Ainun", "1994-07-26", $65000);

INSERT INTO dboAccountManagers VALUES (9, "Bolled", "Bigmac", "1994-07-26", "$65000");

INSERT INTO dboAccountManagers VALUES (11, "Bolled", "Bigmac", "1994-07-26", "65000");

INSERT INTO dboAccountManagers VALUES (12, "Hikmat", "Asep", "1994-07-26", 125000);

• Querying Data from Table

SELECT * FROM dboAccountManagers;

SELECT EmployeeID + Salary FROM dboAccountManagers;

SELECT CONCAT(FirstName, LastName) FROM dboAccountManagers;

SELECT CONCAT(FirstName, Salary) FROM dboAccountManagers;

SELECT DateOfBirth + EmployeeID FROM dboAccountManagers;

SELECT CONCAT(FirstName, DateOfBirth) FROM dboAccountManagers;