Write SQL queries for the following:

select * From hr.employees

1. display employee_id,first_name, email , email in all lowercase ex 100,Steven,SKING,sking 2. Display employee_id, first_name, commision_pct, new_commission_pct Logic for new_commission_pct - If its null display 0 other wise continue to display commission_pct 3. Display employee_id, first_name, phone_number, area_code Logic for area_code- Display first 3 characters of each phone number only ex 100,Steven,510.123.4567,510 4. Display count of people whose phone_number starts with 590. Display the result as emp_area_code_590 with the count. 5. display employee_id, first_name, length_of_first_name ex 100,Steven,6 6. What is the maximum length of table and colun length in Oracle data. Can table name or column names have spaces 7. display employee_id,name,email,email_in_Initcap (First character in upper case followed by rest in lowercase) 100,Steven,SKING,Sking