We are asked to verify if all songs in the database are present on the ‘All songs’ list.
I have been trying ‘SELECT * FROM songs WHERE ‘title’ NOT IN (SELECT ‘title’ FROM songs);’
I am expecting that if a song in the songs table is not displayed on the API, then it will be returned here.
What resulted was the presentation of the database with no song presented.
New contributor
1