Give SQL commands for the given questions:

Branch

bid bname

b1 UAE

b2 Japan

Departments Employees

did dname bid ssn ename city salary did

d1 Marketing b1 s1 Sara Dubai 100000 d1

d2 Accounting b1 s2 Ahmed Al Ain 50000 d1

d3 Engineer b2 s3 Mohammed Dubai 100000 d2

s4 Hiroyuki Tokyo 75000 d3

24) Display all Departments (whole row)

25) List the name and the city of all employees

26) List the Employees located in Dubai.

27) List the name of all Employees that have salary greater than 75000

28) List the name of the employee that has the biggest salary

29) List the name of the employees and their corresponding department name (result should contain 3 rows).

30) List all possible combinations of the name of employees with the departments without relating the employees to the departments (result should contain 6 rows).

31) List name of employees, name of their corresponding departments and name of their corresponding branches.

32) List the department name and the sum of salary of all employees in the respective department.

33) List name of Employees from the UAE branch