Open Source проект

SELECT * FROM mytable WHERE rowid > 100

CREATE TABLE Category (
    ID_Category    INTEGER PRIMARY KEY ASC AUTOINCREMENT
                           NOT NULL
                           UNIQUE,
    NameOfCategory TEXT    NOT NULL
                           UNIQUE,
    DATE           TEXT    DEFAULT _NoDate_
                           NOT NULL
);

CREATE TABLE Inventory (
    CategoryNumber             INTEGER REFERENCES Category (ID_Category) ON UPDATE CASCADE
                                       NOT NULL,
    InventoryNumber            INTEGER PRIMARY KEY AUTOINCREMENT
                                       UNIQUE
                                       NOT NULL,
    Name                       TEXT    NOT NULL
                                       DEFAULT _NoName_,
    InitialCost                REAL    NOT NULL
                                       DEFAULT (0),
    StandartServiceLifeInYears NUMERIC NOT NULL
                                       DEFAULT (0),
    EstimatedFactorOrValueGain NUMERIC NOT NULL
                                       DEFAULT (0),
    ActualServiceLifeInYears   NUMERIC NOT NULL
                                       DEFAULT (0),
    DATE                       TEXT    DEFAULT _NoDate_
);

CREATE VIEW Score AS
    SELECT Инвентаризация.F3 AS f3,
           Инвентаризация.F4 AS f4,
           (Инвентаризация.C3/ Инвентаризация.B3) AS fcb
      FROM Инвентаризация

CREATE TABLE Orders (
    Id         INTEGER PRIMARY KEY,
    CreatedAt  DATE,
    CustomerId INTEGER REFERENCES Customers (Id) ON DELETE NO ACTION
                                                 ON UPDATE NO ACTION,
    ValA       INTEGER,
    ValB       INTEGER
);
CREATE TABLE Customers (
    Id   INTEGER PRIMARY KEY,
    Name VARCHAR,
    ValC INTEGER
);

SELECT Customers.Name AS Customer,
       (Orders.ValA / Orders.ValB) AS VAL1,
       (Customers.ValC / Orders.ValB) AS VAL2
FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.Id

CREATE VIEW CustomersView AS
SELECT * FROM Customers

SELECT Inventory.InitialCost AS FullCost,
(Inventory.ActualServiceLifeInYears / Inventory.StandartServiceLifeInYears)
AS FIcoefficient,
(Inventory.InitialCost * Inventory.EstimatedFactorOrValueGain) 
AS ReplacementCost,
(Score.ReplacementCost - Score.FullCost) / Score.FullCost
AS MIcoefficient,
(Score.ReplacementCost*Score.FIcoefficient * Score.MIcoefficient)/12
AS MonthlyDeductions,
(Score.ReplacementCost*Score.FIcoefficient * Score.MIcoefficient)
AS AnnualDeductions,
(Score.FullCost-Score.AnnualDeductions)
AS AssesedValue
FROM Inventory INNER JOIN Score ON Inventory.InventoryNumber=Score.ID