# CREATE TABLE titles ( isbn TEXT, year INT, titles TEXT, publisher TEXT, authors MAP, 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