#to modify the data and string 
#to get data systematic
#SELECT CONCAT ('HEY',' Buddhi',' hello'); # method to concate and give space between them 
#SELECT CONCAT ('HEY',' ',' hello'); # free space for space between
CREATE table employees(
    emp_id INT  PRIMARY KEY AUTO_INCREMENT,
    fname VARCHAR(50) NOT NULL,
    lname VARCHAR(50) NOT NULL,
    desig VARCHAR(50) NOT NULL DEFAULT 'Probation',
    dept VARCHAR(50) NOT NULL
);
INSERT into employees (emp_id,fname,lname,desig,dept) VALUES (101,'RAJU','DWIVEDI','Manager','Loan');
INSERT into employees (fname,lname,desig,dept) VALUES ('SHAM','SUNDAR','CASHIER','CASH');
INSERT into employees (fname,lname,desig,dept) VALUES ('PAUL','TIWARI','ASSOCIATE','LOAN');
INSERT into employees (fname,lname,desig,dept) VALUES ('ALEX','MISHRA','ACCOUNTANT','LOAN');
INSERT into employees (fname,lname,desig,dept) VALUES ('VICTOR','TRIPATHI','ASSOCIATE','DEPOSIT');
SELECT * FROm employees;
SELECT emp_id, CONCAT(fname,' ', lname) as FULLNAME from employees;
SELECT emp_id, CONCAT (fname,' ', 'JAI HIND') as NewName From employees;