Exercise: BETWEEN and IN

From the tracks table, find every track whose duration_seconds is between 180 and 300 inclusive. Return title and duration_seconds, ordered by duration_seconds ascending.

From the users table, find every user whose country is 'US', 'GB', or 'JP'. Return username and country, ordered by username ascending.

From the users table, find every user from 'US', 'GB', or 'JP' who signed up in 2024 (between 2024-01-01 and 2024-12-31 inclusive). Return username, country, and signup_date.

From the tracks table, find every track whose album_id is in (1, 3, 5) AND whose duration_seconds is between 200 and 250 inclusive. Return title, album_id, and duration_seconds.

rom the users table, find every user whose signup_date is in 2023 (between 2023-01-01 and 2023-12-31 inclusive) AND whose country is NOT in ('US', 'KR'). Return username, country, and signup_date, ordered by signup_date ascending.

Using the users and artists tables, find every user whose country does NOT appear in the artists table. Return username and country.