SELECT REVERSE('HELLO');
#UPPER and LOWER

select upper('abcdefghijklmnopqrstuvwxyz'); #UCASE
select lower('ABCDEFGHIJKLMNOPQRSTUVWXYZ'); #LCASE


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,lower(fname) from employees;

SELECT emp_id, REVERSE(fname) as rnamee from employees;