-
Notifications
You must be signed in to change notification settings - Fork 0
/
queries
19 lines (13 loc) · 621 Bytes
/
queries
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
CREATE DATABASE bikes;
\c bikes
rowery:
CREATE TABLE rowery (id serial PRIMARY KEY, nazwa VARCHAR(255), cena FLOAT );
INSERT INTO rowery (nazwa, cena) VALUES ('orbea', 1000);
INSERT INTO rowery (nazwa, cena) VALUES ('specialized', 2000);
INSERT INTO rowery (nazwa, cena) VALUES ('trek', 3000);
INSERT INTO rowery (nazwa, cena) VALUES ('pinarello', 2500);
INSERT INTO rowery (nazwa, cena) VALUES ('btwin', 100);
transakcje:
CREATE TABLE transakcje ( id serial PRIMARY KEY, data VARCHAR(10), id_rower INT, wartosc FLOAT, ilosc INT);
widok:
CREATE VIEW dzienna AS SELECT sum(wartosc) AS cala_wartosc FROM transakcje;