Соотнесите примеры нормативных правовых актов и их виды в зависимости от юридической силы:
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.
Consider the STUDENT table:
Calculate the result of the following query:
SELECT AVG(RAITING) FROM STUDENT