Crowdly
Add to Chrome
Consider the following table named STUDENT and the ne...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Consider the following table named STUDENT
| ID | NAME | ID_INSTITUTE | RATING |
| 1 | Левицький А. | ||
| 2 | Стернюк У. | I1 | 3.8 |
| 3 | Войтенко М. | I2 | 3.5 |
| 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 FULL JOIN INSTITUTE ON STUDENT.ID_INSTITUTE=INSTITUTE.ID
❌
❌
❌
❌
✅