Check your knowledge: DEVELOPERS Tests Course Materials & Test Answers | softserve.academy

There

are 2 tables: Offices and Cities. They are linked by City_id. At the moment

these tables have the following data

Which

of the next queries will return 3 rows?

SELECT Offices.Name, Cities.Name FROM Offices LEFT OUTER JOIN Cities ON Offices.City_id=Cities.City_id;

100%

SELECT Offices.Name, Cities.Name FROM Offices INNER JOIN Cities ON Offices.City_id=Cities.City_id;

SELECT Offices.Name, Cities.Name FROM Offices RIGHT OUTER JOIN Cities ON Offices.City_id=Cities.City_id;

SELECT Offices.Name, Cities.Name FROM Offices CROSS JOIN Cities

SELECT Offices.Name, Cities.Name FROM Offices FULL OUTER JOIN Cities ON Offices.City_id=Cities.City_id;

View this question

Crowdly