answer it in Sql ;

1- Use the CASE expression and the WF_COUNTRIES table to display COUNTRY_NAME and a column called GENERAL based on the following conditions: If the length of the CAPITOL is 5, it will display 'GROUP_A' If the length of the CAPITOL is 15, it will display 'GROUP_B' Otherwise, it will display 'GROUP_C' Display only those COUNTRY_NAME which has POPULATION_GROWTH_RATE >3 and the COASTLINE is 0 to 1. Arrange the output on COUNTRY_NAME from z to a.

-Using subquery, display the STAFF_TYPE and months between the system date and the birthdate with the column name To Validate from F_STAFFS table, whose STAFF_TYPE is same as the STAFF_TYPE Cook and the second letter of the First_Name is o. Arrange the output on birthdate from newest to the oldest date.

2-Create a query with USING clause to join the EMPLOYEES and JOBS table. Display the LAST_NAME and the first four (4) letters of the EMAIL and name the column as Contact Details. Restrict the output to only Job_id of AD_VP or SA_REP or the FIRST_NAME start with the letter J. Arrange the output on LAST_NAME from lowest to highest.

3-Using subquery, display REGION_ID and the average of POPULATION for each REGION_ID from WF_COUNTRIES table whose average POPULATION is greater than any of the average of POPULATION of each REGION_ID which has a COASTLINE. Arrange the output on REGION_ID from lowest to highest.