# CREATE TABLE titles
(
  isbn   TEXT,
  year   INT,
  titles  TEXT,
  publisher TEXT,
  authors MAP<INT,TEXT>,
  circulation INT,
  issue TEXT,
  PRIMARY KEY(publisher, issue, isbn)
);

# INSERT INTO titles(isbn, year, title, publisher, authors, circulation, issue) VALUES('978-3836244091', 2017, 'Nur noch dieses Level!', 'Rheinwerk', {1 : 'Richard Eisenmenger'}, 1, '18/01');

INSERT INTO titles(isbn, year, title, publisher, authors, circulation, issue) VALUES('978-3836262477', 2018, 'Objektorientierte Programmierung', 'Rheinwerk', {1 :'Bernhard Lahres', 2 : 'Gregor Rayman', 3 : 'Stefan Strich'}, 4, '18/09');

# SELECT Title FROM titles WHERE authors CONTAINS 'Stefan Strich' ALLOW FILTERING;

 Title
----------------------------------
 Objektorientierte Programmierung