Write a query that list all songs that are either: Strictly shorter than one minute. Note that one minute is 60,000 milliseconds. At least one hour long. Note that one hour is 3,600,000 milliseconds

Q&A DQ Courses
#1

Screen Link:
https://app.dataquest.io/m/2000586/filtering-ii-—-complex-expressions-assessment/4/question-4

What actually happened:

I would like to know the solution to the Complexity Expression Assessment

#2

Hi @j.adeyemi.thomas,

Welcome to the Community!

Solution:

SELECT name
  FROM track
 WHERE milliseconds<60000 
    OR milliseconds>=3600000;
1 Like
#3

Thanks Elena. I was later able to figure it out after several tries.

SELECT *
FROM track
WHERE milliseconds<=59999
OR milliseconds >=3600000;

1 Like