A community radio station wants to surface love-themed tracks of standard radio length, restricted to those with a known composer (so they can credit them on air).
| Column | Type |
|---|---|
| TrackId | INTEGER (Primary Key) |
| Name | TEXT NOT NULL |
| AlbumId | INTEGER |
| GenreId | INTEGER |
| Composer | TEXT |
| Milliseconds | INTEGER NOT NULL |
| UnitPrice | NUMERIC(10,2) NOT NULL |
Name contains the word "love" (case-insensitive)Milliseconds between 180,000 and 360,000 (inclusive) — i.e., 3 to 6 minutesComposer is not NULLTitle (Track.Name), Composer, DurationSeconds (Milliseconds / 1000, integer division is fine)Ready to take your skills to the next level? Enroll in our comprehensive Data Analyst Career Track to master SQL, Python, Excel, and Power BI.
Run your code to see the result here.