demo

authors

id, name, country

3 rows

books

id, title, author_id, year, genre

4 rows

Custom SQL query

Schema

CREATE TABLE [authors] (
   [id] INTEGER PRIMARY KEY,
   [name] TEXT,
   [country] TEXT
);
CREATE TABLE "books" (
   [id] INTEGER PRIMARY KEY,
   [title] TEXT,
   [author_id] INTEGER REFERENCES [authors]([id]) ON UPDATE CASCADE ON DELETE CASCADE,
   [year] INTEGER,
   [genre] TEXT
);
CREATE TABLE sqlite_stat1(tbl,idx,stat);
CREATE TABLE sqlite_stat4(tbl,idx,neq,nlt,ndlt,sample);