Skip to content

Latest commit

 

History

History

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 

README.md

Download chinnok db

References

sqlite tutoral

Guide

curl -LO https://cdn.sqlitetutorial.net/wp-content/uploads/2018/03/chinook.zip
unzip chinook.zip

Download a SQLPro viewer (optional)

brew cask install sqlpro-for-sqlite

tracks from album 1

SELECT name, milliseconds, bytes, albumid FROM tracks WHERE albumid = 1;

join example

SELECT title 'title', name 'artist'
FROM albums
JOIN artists ON artists.ArtistId = albums.artistId;

join/where example

```sql
SELECT title 'title', name 'artist'
FROM albums
JOIN artists ON artists.ArtistId = albums.artistId
WHERE artists.name='Pearl Jam'