Crowdly
Add to Chrome
Database & SQL Basics Lite Edition [Ukr+Eng sub, 2016]
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 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 following table named STUDENT
| ID | NAME | ID_INSTITUTE | RATING |
| 1 | Левицький А. | I1 | 4.7 |
| 2 | Стернюк У. | I1 | 3.8 |
| 3 | Войтенко М. | ||
| 4 | Бабич О. | I2 | 4.1 |
and the next table INSTITUTE
| ID | NAME |
| I1 | Computer science |
| I2 | Mathematics |
| I3 | Physics |
which have a relationship by the field ID_INSTITUTE
How many records would the following query produce
SELECT STUDENT.ID, STUDENT.NAME, INSTITUTE.NAME
FROM STUDENT, INSTITUTE
WHERE STUDENT.ID_INSTITUTE=INSTITUTE.ID
Consider the following table named USER
How many records will the following query will produce:
SELECT * FROM USER WHERE NAME LIKE ‘%ivan%’
Consider the table named COUNTRIES:
Determinethe count of countries for 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:
FOREIGH KEY is one or several fields of a table that contain a reference to the primary key field in another table.