Crowdly
Додати до Chrome
Database & SQL Basics Lite Edition [Ukr+Eng sub, 2016]
Шукаєте відповіді та рішення тестів для Database & SQL Basics Lite Edition [Ukr+Eng sub, 2016]? Перегляньте нашу велику колекцію перевірених відповідей для Database & SQL Basics Lite Edition [Ukr+Eng sub, 2016] в softserve.academy.
Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!
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.* FROM EMPLOYEE E WHERE E.SALARY = ( SELECT MAX(SALARY) FROM EMPLOYEE E2
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