Consider the following table named STUDENT

 and the next table INSTITUTE

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.

Consider the following table named STUDENT 

and the next table INSTITUTE

which have a relationship by the field ID_INSTITUTE

What is the query that would produce the following result set: