Table Name: DEPT D.id DName 111 Sales Building First Second 112 Accounts 113 First Service HR 114 Second Table Name: EMP Eld Ename Do Depno 113 E101 Ahmed E102 Gaith 111 E103 Hafsa Salary 300.000 625 250 550.564 700456 450.750 850.556 2008-07-15 2009-09-12 2010-04-12 2011-07-25 2012-07-05 2012-07-05 E104 E105 Mada Ahmed Zuwina 112 E106 112 1. Write an SQL query to find and display the length of Employee names after removing the letters from their names. 2. Write an SQL query to display unique building and position of lettera in employee names (use inner join). 3. Write an SQL query to display after removing digits after 2 decimal places for the employees whose salary lies in the range 400 and 800 4. Write an SQL query to find the next Tuesday from the date they joined the company and also find the last day of that month in joining date 5. Write an SQL query to combine employee id and employee name for the employees whose salary is more than average salary of all employees 6.Write an SQL query to find minimum salary in each department in the ascending order of department id (use having clause) 7. Write an SQL query to display matched records from department table and employees table for the employees a. Write an SQL query to display the name and salary of the employees who salary is less than average salary. In output names should be displayed in descending order 9. Write an SQL query to display Year from employee's date of joining tion 35 Following are the information given by Sohar Company for its last accounting period OMR red ed out of Average accounts payable 11,000 Average accounts receivable 17,000 Average inventory 9,000 Net sales 100,000 Net purchases 80,000 110,000 Cost of goods sold 1. Calculate Sohar Company's receivable collection period frounded to the nearest whole day) 2. Calculate Sohar Company's inventory conversion period. (rounded to the nearest whole day). 3. Calculate Sohar Company's average payment period. (rounded to the nearest whole day) 4. Calculate Sohar Company's cash conversion cycle. (rounded to the nearest whole day)