How many records may be updated in the EMPLOYEES table by the following query (Assume that ID field is a primary key):

UPDATE EMPLOYEES SET SALARY = SALARY*1.1 WHERE ID IN (1, 3, 5)

A subquery, that have a reference to the columns of the main query, are called

In which commands can we use subqueries?

In which sections of the SELECT command can we use subqueries?

From the EMPL table, list all employees, whose salary (field SAL) is greater than one of employee Шевченко (field NAME):

Consider the EMPLOYEE table, that has the following fields: ID – id number of employee, DEPARTMENT_ID – the id number of the department and SALARY – his monthly wage. What can we obtain by means of the following query:

SELECT E.*

WHERE  E2.DEPARTMENT_ID= E.DEPARTMENT_ID )

Consider the table named COUNTRIES:

Determine the average population on each continent. 

Consider the STUDENT table:

Calculate the result of the following query:

SELECT AVG(RAITING) FROM STUDENT