test_repository/shop_file.sql at main · mildaug/test_repository · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114

--Customers
INSERT INTO customer
    (f_name, l_name, email)
VALUES
    ("Jotautas", "Treigys", "jtr@gmail.com");

INSERT INTO customer
    (f_name, l_name, email)
VALUES
    ("Laura", "Sauliene", "lsauliene@gmail.com");

INSERT INTO customer
    (f_name, l_name, email)
VALUES
    ("Laurynas", "Suodaitis", "lsuo@gmail.com");

INSERT INTO customer
    (f_name, l_name, email)
VALUES
    ("Agne", "Liete", "lietea@gmail.com");

--Status
INSERT INTO status
    (name)
VALUES
    ("Atmestas");

INSERT INTO status
    (name)
VALUES
    ("Patvirtintas");

INSERT INTO status
    (name)
VALUES
    ("Neapmoketas");

INSERT INTO status
    (name)
VALUES
    ("Atsauktas");


--Order
INSERT INTO order_
    (date_, status_id)
VALUES
    ("2020-11-14", 1);

INSERT INTO order_
    (date_, status_id)
VALUES
    ("2023-01-08", 4);

INSERT INTO order_
    (date_, status_id)
VALUES
    ("2021-03-14", 2);

INSERT INTO order_
    (date_, status_id)
VALUES
    ("2018-12-20", 3);

--Product
INSERT INTO product
    (name, price)
VALUES
    ("Tulpes", "18");

INSERT INTO product
    (name, price)
VALUES
    ("Bijunai", "25");

INSERT INTO product
    (name, price)
VALUES
    ("Protejos", "40");

INSERT INTO product
    (name, price)
VALUES
    ("Leukonijos", "11");

--Product order
INSERT INTO product_order
    (quantity)
VALUES
    ("100");

INSERT INTO product_order
    (quantity)
VALUES
    ("150");

INSERT INTO product_order
    (quantity)
VALUES
    ("50");

INSERT INTO product_order
    (quantity)
VALUES
    ("25");


--Uzklausos

SELECT customer.id, customer.l_name, customer.f_name, customer.email
FROM customer
JOIN order_
ON customer.id=order_.customer_id