In Question 2 on 5_Joins_Homework.SQL file there is a spelling mistake.
When you say StateProvideName I think you mean to say StateProvinceName
In the explanation video you have it spelt right.
/*
Q2
Return two columns:
StateProvinceName, CountryName
Return rows for all Countries, with a related StateProvideName IF it exists.
The query should return 242 rows.
Write two versions of the query, one with a LEFT OUTER JOIN,
and one with a RIGHT OUTER JOIN
*/
In Question 2 on 5_Joins_Homework.SQL file there is a spelling mistake.
When you say StateProvideName I think you mean to say StateProvinceName
In the explanation video you have it spelt right.
/*
Q2
Return two columns:
StateProvinceName, CountryName
Return rows for all Countries, with a related StateProvideName IF it exists.
The query should return 242 rows.
Write two versions of the query, one with a LEFT OUTER JOIN,
and one with a RIGHT OUTER JOIN
*/