-- create CREATE TABLE books ( bookid INTEGER PRIMARY KEY, name TEXT NOT NULL, typeid INTEGER NOT NULL, price INTEGER NOT NULL, pagecount INTEGER NOT NULL ); -- insert INSERT INTO books VALUES (0001, 'Дюна', 1, 1200, 1000); INSERT INTO books VALUES (0002, 'Черновик', 3, 500, 800); INSERT INTO books VALUES (0003, 'Чистовик', 2, 800, 586); INSERT INTO books VALUES (0004, 'Отцы и Дети', 9, 456, 400); INSERT INTO books VALUES (0005, 'Мастер и Маргарита', 1, 505, 1200); INSERT INTO books VALUES (0006, 'Белая гвардия', 7, 900, 250); INSERT INTO books VALUES (0007, 'Мертвые души', 1, 1600, 1000); INSERT INTO books VALUES (0008, 'Война и Мир', 1, 950, 310); INSERT INTO books VALUES (0009, 'Метро 2033', 2, 2000, 600); INSERT INTO books VALUES (0010, 'Дюна', 1, 1200, 1000); -- fetch SELECT * FROM books;

The provided example creates a books table with fields: bookid (primary key), name (book title), typeid (book type), price (price), and pagecount (number of pages). Then, records with book data are inserted into the table.

Example of creating and inserting data:

CREATE TABLE books (
  bookid INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  typeid INTEGER NOT NULL,
  price INTEGER NOT NULL,
  pagecount INTEGER NOT NULL
);

INSERT INTO books VALUES (1, 'Dune', 1, 1200, 1000);
INSERT INTO books VALUES (2, 'Draft', 3, 500, 800);
-- and so on

SELECT * FROM books;

Note that in SQL, numbers with leading zeros (e.g., 0001) are interpreted simply as 1. Also, it is important that the bookid field is unique and serves as the book's identifier.

This example demonstrates basic operations of creating a table, inserting data, and selecting all records.