B$.$ Consider the "emp" and "dept" tables from a part of the relational database schema of "Company" database given below, and answer the following questions:

$)=(5$ marks

Emp $($empno$,$ ename, job, hiredate, sal, comm, deptno$)$

dept $($deptno$,$ dname, loc$)$

Write the SQL statement to display all employees having salary less than $$10,000.$ such that the records are listed by ascending order according to the salary?

Write the SQL statement to display employee number, name, job, and salary of all employees whose employee's name starting with letter $"$A$"?$

We want to increase the salary of employee "Turki" with $$500,$ and he will transfer to department number $2?$ Write the SQL statement to modify Turki $\text{'}$s record?

Write the $SQL$ statement to display the total, maximum, and minimum salary for each department?

Write the Relational Algebra statements to retrieve the employee's name, job, salary, and department name for all employees having salary greater than $$10,000?$ using Join operation? Pls solve it all with steps