![](https://i.imgur.com/9UQ54uc.gif"){kind=small}
Hello friends, I have an exam tomorrow and my teacher provided me with the questions he asked last year to study, but I couldn't solve some of them. Could you help me? Here are the questions I am stuck on:
1 - Write an SQL statement that creates a view table holding department information where the annual average salary is over 200,000 TL.
2 - Given that the Personnel and Department tables are in the same database, what is the query to find the managers of the "Information Technology" and "Accounting" departments?
3 - Write an SQL statement that lists the first and last names of employees in the personnel table who are female and born after 01/01/1980, with the initials in uppercase.
Table Information:
Personnel Table: emp_id | first_name | last_name | gender | birth_date | salary | dept_code
Department Table: dept_code | dept_name | dept_room_no | dept_manager_id
1 - Write an SQL statement that creates a view table holding department information where the annual average salary is over 200,000 TL.
2 - Given that the Personnel and Department tables are in the same database, what is the query to find the managers of the "Information Technology" and "Accounting" departments?
3 - Write an SQL statement that lists the first and last names of employees in the personnel table who are female and born after 01/01/1980, with the initials in uppercase.
Table Information:
Personnel Table: emp_id | first_name | last_name | gender | birth_date | salary | dept_code
Department Table: dept_code | dept_name | dept_room_no | dept_manager_id