aziona_tutorial_API_SQLite.sql

CREATE TABLE IF NOT EXISTS album (
    `ID` INT PRI,
    `ARTIST` VARCHAR(30),
    `ALBUM` VARCHAR(30),
    `GENRE` VARCHAR(30),
     PRIMARY KEY (ID)
);
INSERT INTO album VALUES
    (1,'Pantera','Official Live','Trash Metal'),
    (2,'Sepultura','Roots','Death Metal'),
    (3,'Obituary','Obituary','Death Metal'),
    (4,'Spliknot','IOWA','NU Metal'),
    (5,'Biohazard','Mata Leao','Crossover Metal'),
    (6,'Sepultura','Chaos AD','Death Metal'),
    (7,'Soulfly','Soulfly','NU Metal'),
    (8,'Megadeth','Rest in Pieces','Trash Metal'),
    (9,'Machine Head','Blackening','NU Metal');

This gist has been used on 2021 to create a tutorial for Azionadigitale.com