corndel-swe / topsify

A global music streaming app
0 stars 1 forks source link

2b solution #2

Closed AndrewYHuang closed 4 months ago

AndrewYHuang commented 7 months ago

I might be missing something here, I've got

-- Find the track_id of all tracks whose "speechiness" is greater than 0.5
-- but sort them by their danceability, with least danceable tracks first
-- (Hint: use the features table)

SELECT track_id 
FROM features 
WHERE speechiness > 0.5 
ORDER BY danceability ASC;

But my actual tracks is a superset of the expected ones - Has there been more added to the seed data since this exercise?

nimonian commented 4 months ago

I'm not certain but I ran this query and it passes the test now, so must have been some isssue with the database which is now sorted.