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!
Consider the STUDENT table:
Calculate the result of the following query:
SELECT AVG(RAITING) 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:
Determinethe count of countries for each continent
Consider the STUDENT table
Calculate the result of the following query:
SELECT SUM(RAITING) FROM STUDENT
Consider the following table named USER
How many records will the following query will produce:
SELECT * FROM USER WHERE NAME LIKE ‘Ivan%’
Consider the following table named USER
How many records will the following query will produce:
SELECT * FROM USER WHERE NAME LIKE ‘%ivan%’