You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
As I understood from (1) the next query should be to select ONLY Artists that don't have an Album. But query (2) selects Artists with and without Album. In video on the screen display only Artists without Album, but if scroll up, also present Artists with Album. Seems in query missing WHERE A.ArtistId IS NULL; part.
Also for me, strange sentence (3) in context of (1) and (2) above. OUTER verb don't add any functionality to query, and we could omit that. But in (3) might get the impression that this verb have effect to filter Artists with albums.
The text was updated successfully, but these errors were encountered:
https://sqlite.holt.courses/lessons/intermediate-sql/other-types-of-joins
As I understood from (1) the next query should be to select ONLY Artists that don't have an Album. But query (2) selects Artists with and without Album. In video on the screen display only Artists without Album, but if scroll up, also present Artists with Album. Seems in query missing
WHERE A.ArtistId IS NULL;
part.Also for me, strange sentence (3) in context of (1) and (2) above. OUTER verb don't add any functionality to query, and we could omit that. But in (3) might get the impression that this verb have effect to filter Artists with albums.
The text was updated successfully, but these errors were encountered: