Change Case of Guest Name
Write a query to display the guest name in proper case. For instance the guest name “geeta govind” should be displayed as “Geeta Govind”. Give alias name as GUESTNAME. Sort the result based on Guest Name.
select INITCAP(name) as GUESTNAME from Guest order by GUESTNAME;