SQL Intermediate Question - 2 String Bases Question 

Question - Segregate the name into first name and last name and keep them in correct order of caps.
Table Creation Query :-
create table names(
name varchar(30));
insert into names
values('aNkiT DhAR'),
('RahUL BhaTIYa');