Looking for Database & SQL Basics Lite Edition [Ukr+Eng sub, 2016] test answers and solutions? Browse our comprehensive collection of verified answers for Database & SQL Basics Lite Edition [Ukr+Eng sub, 2016] at softserve.academy.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
What is wrong with this query:
SELECT * FROM EMPLOYEE WHERE DEPARTMENT = (SELECT DEPARTMENT FROM EMPLOYEE WHERE SALARY > 1000)
Which of the given statements describes the action of the following query:
SELECT * FROM PRODUCTS WHERE NOT EXISTS (SELECT * FROM ORDERS WHERE ORDERS.ID_PRODUCT = PRODUCTS.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 COUNT(*) FROM STUDENT
Consider the table named COUNTRIES
The following query:
SELECT CONTINENT, COUNT(COUNTRY)
FROM COUNTRIES
GROUP BY CONTINENT
HAVING SUM(POPULATION) > 300
would give us the information about:
Consider the table named COUNTRIES:
Determine the average population on each continent.