Most Expensive Tracks (chinook database)
Easy
3
84.2% Acceptance
Your objective in this lab is to test and hone your SQL skills using the chinook dataset.
Database Schema:
Below is a quick reminder of the table structures:
-
Artist
:- "ArtistId" (Primary Key)
- "Name"
-
Album
:- "AlbumId" (Primary Key)
- "Title"
- "ArtistId" (Foreign Key to "Artist")
-
Track
:- "TrackId" (Primary Key)
- "Name"
- "AlbumId" (Foreign Key to "Album")
- "UnitPrice"
Instructions:
- Ensure you are using SQLite-compatible syntax and functions.
- Make sure to always use double quotes around table and column names for clarity.
- Adhere strictly to the provided table and column names.
- Remember to often use the
ORDER BY
clause in your queries. The ordering of results is crucial for accurate evaluation. - Ensure that the names and order of the columns in your solution match the instructions provided in each challenge.
Challenges:
1. High-Priced Tunes: Identify the top 10 tracks with the highest prices. Your result should have two columns: "Name" and "UnitPrice". Make sure to order your results by "UnitPrice" in descending order to get the priciest tracks at the top.
Tips:
- Pay close attention to the exact column names and table structures provided.
- Always verify your queries and results before final submission.
- Remember, precision and attention to detail are key to succeeding in this lab.
Challenges Information
Challenge 1: High-Priced Tunes
Objective: Your task is to identify the tracks that have the highest prices in the chinook dataset.
Details:
- Tables to Use:
Track
- Columns to Select:
Name
,UnitPrice
- Order: You will need to order the results based on the
UnitPrice
column in descending order to find the most expensive tracks first. - Limitation: Limit your output to the top 10 results to identify the ten most expensive tracks.
- Output Columns: Your final output should consist of two columns:
Name
(to identify the track) andUnitPrice
(to show the cost of the track).
Expected SQL Structure:
SELECT "Name", "UnitPrice" FROM "Track" ORDER BY "UnitPrice" DESC LIMIT 10;
Make sure to adhere to the provided structure and requirements for accurate results. Good luck!