Distinct city names (chinook database)

Easy
85
2
94.7% Acceptance

In this exercise, you'll be working with the chinook database. Your task is to solve a series of challenges that test your SQL skills.

Lab Dataset

You'll be using the chinook database, which represents a digital music shop. Here's a quick breakdown of the tables and the key columns:

  • Artist: "ArtistId", "Name"
  • Album: "AlbumId", "Title", "ArtistId"
  • Track: "TrackId", "Name", "AlbumId", "MediaTypeId", "GenreId", "Composer", "Milliseconds", "Bytes", "UnitPrice"
  • MediaType: "MediaTypeId", "Name"
  • Genre: "GenreId", "Name"
  • Playlist: "PlaylistId", "Name"
  • PlaylistTrack: "PlaylistId", "TrackId"
  • Invoice: "InvoiceId", "CustomerId", "InvoiceDate", "BillingAddress", "BillingCity", "BillingState", "BillingCountry", "BillingPostalCode", "Total"
  • InvoiceLine: "InvoiceLineId", "InvoiceId", "TrackId", "UnitPrice", "Quantity"
  • Customer: "CustomerId", "FirstName", "LastName", "Company", "Address", "City", "State", "Country", "PostalCode", "Email", "SupportRepId"
  • Employee: "EmployeeId", "LastName", "FirstName", "Title", "ReportsTo", "BirthDate", "HireDate", "Address", "City", "State", "Country", "PostalCode", "Phone", "Fax", "Email"

Instructions

  1. Writing SQL Queries: Write SQL queries to solve the challenges. Make sure to name all the columns exactly as mentioned in the challenge statement.
  2. Using Double Quotes: Whenever referencing column names or table names, use double quotes for clarity, e.g., SELECT "Name" FROM "Artist".
  3. Order Matters: Always ensure that the ordering specified in the challenge is strictly followed. This is important to make sure your solution matches the expected output, as the evaluation may involve direct comparison of rows.
  4. Be Precise: Ensure that the queries you write follow the exact specifications of the challenges. Avoid adding or removing columns that are not explicitly mentioned.

When you're ready to submit, ensure your SQL query matches the problem statement's requirements, and remember to test your solution to ensure accuracy!

Good luck, and happy querying!

Challenges Information

Challenge 1: Distinct Customer Cities

Objective: Fetch a list of all the unique cities in which the customers live.

Details:

  • Dataset: Use the Customer table from the chinook database.
  • Columns to Display: Display the City column.
  • Ordering: Results should be ordered alphabetically by the city name.
  • Uniqueness: Ensure that each city name appears only once in the result.