Case-Sensitive Search

Easy
1
47.8% Acceptance

Welcome to this SQL coding lab! Your task is to solve a set of SQL challenges based on the Chinook database, using SQLite syntax.

Database Schema

We are using specific tables from the Chinook database for these challenges. The tables you'll be working with are: Artist, Album, Track, MediaType, Genre, Playlist, PlaylistTrack, Invoice, InvoiceLine, Customer, and Employee.

Instructions

  • Use SQLite syntax for all queries.
  • Stick to the exact table and column names as they appear in the Chinook database schema.
  • Use double quotes around column and table names for clarity.
  • All challenges require you to use the ORDER BY clause to sort the results.

Challenge

Table Used:

  • Track

Task Description:

  • Perform a case-sensitive search to identify tracks that contain specific words in their names. You should use the COLLATE BINARY clause for case-sensitive search.

Columns to Display in Final Output:

  • TrackId
  • Name

Sorting Requirement:

  • Results should be ordered by TrackId.