it's my Lab 7: Songs solution... *Please just take a look if you couldn't solve it ... Thank you 🙂 #cs50

songs.sql

-- 1.sql
SELECT name FROM songs;
-- 2.sql
SELECT name FROM songs ORDER BY tempo;
-- 3.sql
SELECT name FROM songs ORDER BY duration_ms DESC LIMIT 5;
-- 4.sql
SELECT name FROM songs WHERE danceability > 0.75 AND energy > 0.75 AND valence > 0.75;
-- 5.sql
SELECT avg(energy) FROM songs;
-- 6.sql
SELECT name FROM songs WHERE artist_id = (SELECT id FROM artists WHERE name == "Post Malone");
-- 7.sql
SELECT avg(energy) FROM songs WHERE artist_id = (SELECT id FROM artists WHERE name == "Drake");
-- 8.sql
SELECT name FROM songs WHERE name LIKE "%feat.%";

Thanks this really helped me

you can just put SELECT name FROM songs WHERE artist_id = (SELECT id FROM artists WHERE name = "Post Malone");
since single "=" sign in SQL indicates equality as there is no concept of assignment in this language

I got an error like Error when executing query: Not an executable object: 'SELECT 1'. what to do?

What's the solution of answer.txt

fhgdhh

i ran q 5 and it gave me a syntax error

i ran q 5 and it gave me a syntax error

TRY writing AVG( ) instead of avg( )

What's the solution of answer.txt

I couldn't find it, Can you help me?

where to write all these solutions

WHat to put in answers.txt?

Read the instructions, before the Testing section, there is another section (Spotify Wrapped) in that section there are two questions, you must answer those question in your answers.txt file.

Answers.txt is literally just reflection questions, read the instructions -_-

someone can help me solving this problem set? please +52 5518382237