Problema 1
SELECT sysdate
FROM dual
DROP TABLE pacienti
CREATE TABLE pacienti
(
id NUMBER(3) PRIMARY KEY,
cnp NUMBER(13) NOT NULL,
nume VARCHAR2(50) NOT NULL,
prenume VARCHAR2(50) NOT NULL,
data_nasterii DATE NOT NULL,
medic_familie VARCHAR2(100) NOT NULL
)
DESCRIBE pacienti
DROP TABLE analize
CREATE TABLE analize
(
id NUMBER(3) PRIMARY KEY,
idp NUMBER(3) REFERENCES pacienti(id) NOT NULL,
denumire VARCHAR2(50) NOT NULL,
data_efectuare DATE NOT NULL,
referinta_min NUMBER(6) NOT NULL,
referinta_max NUMBER(6) NOT NULL,
valoare_efectiva NUMBER(6) NOT NULL,
observatii VARCHAR2(200)
)
DESCRIBE analize
INSERT INTO pacienti
VALUES (10, 5020530330683, 'Alexa', 'Sebastian', '30-MAY-02',
'Dimitru Andreea')
INSERT INTO pacienti
VALUES (11, 5040316330925, 'Leonte', 'Stefan', '16-MAR-04', 'Voicu
Claudiu')
INSERT INTO pacienti
VALUES (12, 4851123330388, 'Horea' , 'Roman', '23-NOV-85',
'Dimitru Andreea')
INSERT INTO pacienti
VALUES (13, 4790714330902, 'Ciodaru', 'Stefan', '14-JUL-79',
'Ciobanu Ramona')
INSERT INTO pacienti
VALUES (14, 4920106330670, 'Varujan', 'Ion', '06-JAN-92', 'Voicu
Claudiu')
SELECT *
FROM pacienti
INSERT INTO analize (id, idp, denumire, data_efectuare,
referinta_min, referinta_max, valoare_efectiva)
VALUES (1, 10, 'Glicemie', '05-JAN-23', 100, 200, 100)
INSERT INTO analize (id, idp, denumire, data_efectuare,
referinta_min, referinta_max, valoare_efectiva)
VALUES (2, 10, 'Glicemie', '10-APR-23', 100, 200, 150)
INSERT INTO analize (id, idp, denumire, data_efectuare,
referinta_min, referinta_max, valoare_efectiva)
VALUES (3, 11, 'Glicemie', '15-JUL-23', 120, 180, 110)
INSERT INTO analize (id, idp, denumire, data_efectuare,
referinta_min, referinta_max, valoare_efectiva)
VALUES (4, 11, 'Glicemie', '20-OCT-23', 120, 180, 130)
INSERT INTO analize (id, idp, denumire, data_efectuare,
referinta_min, referinta_max, valoare_efectiva)
VALUES (5, 12, 'Glicemie', '25-JAN-24', 110, 210, 170)
INSERT INTO analize (id, idp, denumire, data_efectuare,
referinta_min, referinta_max, valoare_efectiva)
VALUES (6, 12, 'Glicemie', '10-JAN-21', 110, 210, 140)
INSERT INTO analize (id, idp, denumire, data_efectuare,
referinta_min, referinta_max, valoare_efectiva)
VALUES (7, 13, 'Glicemie', '03-DEC-21', 100, 190, 180)
INSERT INTO analize (id, idp, denumire, data_efectuare,
referinta_min, referinta_max, valoare_efectiva)
VALUES (8, 13, 'Glicemie', '17-FEB-20', 100, 190, 120)
INSERT INTO analize (id, idp, denumire, data_efectuare,
referinta_min, referinta_max, valoare_efectiva)
VALUES (9, 14, 'Glicemie', '20-JUN-22', 140, 210, 220)
INSERT INTO analize (id, idp, denumire, data_efectuare,
referinta_min, referinta_max, valoare_efectiva)
VALUES (10, 14, 'Glicemie', '01-SEP-22', 140, 210, 170)
SELECT *
FROM analize
SELECT nume || ' ' || prenume AS "Nume si prenume"
FROM pacienti
WHERE data_nasterii < '01-JAN-89'
ORDER BY nume DESC
SELECT [Link] || ' ' || [Link] AS "Nume si prenume",
AVG(B.valoare_efectiva) AS "Medie Glicemie"
FROM pacienti A, analize B
WHERE UPPER(TRIM([Link])) LIKE 'GLICEMIE' AND [Link] =
[Link]
GROUP BY [Link], [Link]
Problema 2 - Bolohan și Potop
CREATE TABLE masini
(
id number(2) primary key,
marca varchar2(15) not null,
model varchar2(15) not null,
data_fabricatie date not null,
data_achizitie date not null,
nr_inmatriculare varchar2(10) not null,
nr_km number(8) not null
);
CREATE TABLE reparatii
(
id number(2) primary key,
id_d number(2) references masini (id) not null,
denumire varchar2(20) not null,
cost_materiale number (6) not null,
cost_manopera number(5) not null,
observatii varchar2(20).
);
insert into masini
values('1','Opel','Astra','08-MAR-2018','02-DEC-2018','BV 08
KLO','102455');
insert into masini
values('2','Audi','A5 COUPE','05-MAY-2011','05-MAY-2011','SV 07
POT','275000');
insert into masini
values('3','Mercedes-Benz','GLS','10-JAN-2024','01-MAR-2024','B
500 GMS','1205');
insert into masini
values('4','Audi','Q7','17-APR-2014','09-MAY-2015','SV 27
PLS','187282');
insert into masini
values('5','BMW','X5','23-MAR-2019','04-JUN-2019','SM 44
ASF','55003');
insert into reparatii
values('1','2','distributie','200','100', 'fara observatii');
insert into reparatii
values('2','5','schimbare motor','5000','2000','Motorul e nou');
SELECT * FROM masini
SELECT * FROM reparatii
SELECT marca, model
FROM MASINA
WHERE YEAR(data_achizitie) = 2018;
SELECT [Link], [Link], SUM(r.cost_materiale +
r.cost_manopera) AS valoare_totala_reparatii
FROM MASINA m
JOIN REPARATIE r ON m.nr_inmatriculare = r.nr_inmatriculare
WHERE YEAR(r.data_efectuare) = 2024
GROUP BY [Link], [Link];
Problema 4 - Bouriaud și Carp
CREATE TABLE LOCATII
(
codL NUMBER(6) PRIMARY KEY,
nume_institutie VARCHAR2(70) NOT NULL,
nume_localitate VARCHAR2(70) NOT NULL,
nume_judet VARCHAR2(70) NOT NULL
);
CREATE TABLE PIESE
( codP NUMBER(4) REFERENCES LOCATII(codL) NOT NULL,
nume_P VARCHAR2(70) NOT NULL,
data DATE NOT NULL,
ora NUMBER NOT NULL
);
DROP TABLE LOCATII
DROP TABLE PIESE
DESCRIBE LOCATII
DESCRIBE PIESE
INSERT INTO LOCATII(codL, nume_institutie, nume_localitate,
nume_judet)
Values ('27', 'Biblioteca', 'Falticeni', 'Suceava');
INSERT INTO LOCATII(codL, nume_institutie, nume_localitate,
nume_judet)
Values ('19', 'Teatrul_Matei_Visniec', 'Suceava', 'Suceava');
INSERT INTO LOCATII(codL, nume_institutie, nume_localitate,
nume_judet)
Values ('45', 'Casa_de_cultura', 'Suceava', 'Suceava');
INSERT INTO LOCATII(codL, nume_institutie, nume_localitate,
nume_judet)
Values ('215', 'Teatrul_National_Iasi', 'Iasi', 'Iasi');
INSERT INTO PIESE(codP, nume_P,data, ora)
Values ('19','Tristan si Isolda', '8-01-2024','14');
INSERT INTO PIESE(codP, nume_P,data, ora)
Values ('45','Romeo si Julieta', '8-08-2024','20');
INSERT INTO PIESE(codP, nume_P,data, ora)
Values ('215','Hamlet', '8-01-2024','19');
INSERT INTO PIESE(codP, nume_P,data, ora)
Values ('19','Titanic Vals', '23-04-2024','16');
INSERT INTO PIESE(codP, nume_P,data, ora)
Values ('215','O scrisoare pierduta', '17-10-2024','15');
SELECT * FROM LOCATII
SELECT * FROM PIESE
SELECT nume_P
FROM PIESE
WHERE data=to_date('8-01-2024','dd-mm-yyyy')
SELECT B.nume_P AS "nume_piesa"
FROM LOCATII A, PIESE B
WHERE [Link]=[Link] AND UPPER(TRIM(A.nume_localitate))
LIKE'SUCEAVA'
ORDER BY B.nume_P ASC
Problema 5
DROP TABLE excusie
CREATE TABLE excursie
(
cod_excursie NUMBER(3) PRIMARY KEY,
pret NUMBER (4) NOT NULL,
data DATA NOT NULL,
)
DESCRIBE excursie
INSERT INTO excursie
cod_excursie, pret, data
VALUES
('1' '100' '2024-05-01'),
('2' '99' '2024-03-21'),
('3' '150' '2024-09-09'),
('4' '200' '2023-02-29'),
('5' '500' '2022-02-06'),
DROP TABLE elev
CREATE TABLE ELEV
(
cnp NUMBER(13) PRIMARY KEY,
nume VARCHAR2(50) NOT NULL,
clasa NUMBER (2) NOT NULL,
scoala VARCHAR2(50) NOT NULL,
medie NUMBER(3) NOT NULL,
)
DESCRIBE elev
INSERT INTO elev
cnp, nume, clasa, scoala, medie
VALUES
( '123456789012' 'Balaban' '10A' 'Spiru Haret' '9.5')
('234567890123' 'Costin' '11A' 'Spiru Haret' '8.7 ')
('345678901234' 'Potop' '9' 'Dimitrie Cantemir' '7.9')
('456789012345' 'Ionescu ' '12D' ' Spiru Haret' '9.2')
SELECT Nume, Clasa, Medie
FROM Elev
WHERE Școala = 'Spiru Haret';
SELECT [Link], [Link], [Link], [Link]
FROM Elev e
JOIN Participare p ON [Link] = p.CNP_elev
JOIN Excursie ex ON p.Cod_excursie = ex.Cod_excursie
ORDER BY [Link], [Link];
Problema 7 - Ciungu și Damian
CREATE TABLE TARA
(
cod_t NUMBER(3) PRIMARY KEY,
denumire VARCHAR2(20) NOT NULL,
capitala VARCHAR2(20) NOT NULL
);
CREATE TABLE ORAS
(
cod_o NUMBER(3) PRIMARY KEY,
cod_t NUMBER(3) REFERENCES TARA(cod_t),
nume_o VARCHAR2(20) NOT NULL,
populatie NUMBER(10) NOT NULL
);
INSERT INTO TARA (cod_t, denumire, capitala)
VALUES (11, 'China', 'Beijing');
INSERT INTO TARA (cod_t, denumire, capitala)
VALUES (22, 'Cehia', 'Praga');
INSERT INTO TARA (cod_t, denumire, capitala)
VALUES (33, 'Egipt', 'Cairo');
INSERT INTO TARA (cod_t, denumire, capitala)
VALUES (44, 'Franta', 'Paris');
INSERT INTO TARA (cod_t, denumire, capitala)
VALUES (55, 'Grecia', 'Atena');
INSERT INTO ORAS (cod_o ,cod_t, nume_o, populatie)
VALUES (1, 11, 'Tianjin', 7200000);
INSERT INTO ORAS (cod_o ,cod_t, nume_o, populatie)
VALUES (2, 11, 'Guangzhou', 11810000);
INSERT INTO ORAS (cod_o ,cod_t, nume_o, populatie)
VALUES (3, 22, 'Ostrava', 311402);
INSERT INTO ORAS (cod_o ,cod_t, nume_o, populatie)
VALUES (4, 22, 'Brno', 367729);
INSERT INTO ORAS (cod_o ,cod_t, nume_o, populatie)
VALUES (6, 33, 'Giza', 3258540);
INSERT INTO ORAS (cod_o ,cod_t, nume_o, populatie)
VALUES (5, 33, 'Beheira', 5327000);
INSERT INTO ORAS (cod_o ,cod_t, nume_o, populatie)
VALUES (7, 44, 'Avignon', 88312);
INSERT INTO ORAS (cod_o ,cod_t, nume_o, populatie)
VALUES (8, 44, 'Bordeaux', 218948);
INSERT INTO ORAS (cod_o ,cod_t, nume_o, populatie)
VALUES (9, 44, 'Lyon', 453187);
INSERT INTO ORAS (cod_o ,cod_t, nume_o, populatie)
VALUES (10, 55, 'Salonic', 800764);
INSERT INTO ORAS (cod_o ,cod_t, nume_o, populatie)
VALUES (11, 55, 'Tripolis', 28928);
SELECT [Link] AS TARA,
(SELECT nume_o
FROM ORAS
WHERE TARA.cod_t = ORAS.cod_t
AND [Link] = (SELECT MAX(populatie)
FROM ORAS
WHERE TARA.cod_t = ORAS.cod_t)) AS ORAS,
(SELECT MAX(populatie)
FROM ORAS
WHERE TARA.cod_t = ORAS.cod_t) AS POPULATIE_MAXIMA
FROM TARA
ORDER BY [Link];
SELECT ORAS.nume_o AS ORAS,
[Link],
(SELECT denumire FROM TARA WHERE TARA.cod_t =
ORAS.cod_t) AS TARA,
(SELECT capitala FROM TARA WHERE TARA.cod_t =
ORAS.cod_t) AS CAPITALA
FROM ORAS
WHERE [Link] = (SELECT MIN(populatie) FROM ORAS)
OR [Link] = (SELECT MAX(populatie) FROM ORAS)
ORDER BY [Link];
Problema 8 - Codreanu și Iapara
Problema 10
CREATE TABLE DIRIGINTI
( id NUMBER(3) PRIMARY KEY,
nume VARCHAR2(20) NOT NULL,
clasa VARCHAR2(10) NOT NULL,
specializare VARCHAR2(15) NOT NULL
)
CREATE TABLE ELEVI
( CNP NUMBER(20) PRIMARY KEY,
nume VARCHAR2(20) NOT NULL,
media_generala NUMBER(5) NOT NULL
)
DROP TABLE DIRIGINTI
DROP TABLE ELEVI
DESCRIBE DIRIGINTI
DESCRIBE ELEVI
INSERT INTO DIRIGINTI
VALUES('1','Corocaescu Alina','12A','mate-info')
VALUES('2','Jelea Monica','11B','bio-chimie')
VALUES('3','Freitag Gabriela','10C','filologie')
VALUES('4','Andrei Anca','9F','mate-info')
VALUES('5','Iftode Liliana','12D','bio-chimie')
INSERT INTO ELEVI
VALUES( '607643567','Costin Alexia', '10')
VALUES( '507129877','Bitan Emilut','4')
VALUES( '698392286','Drosceac Rebeca','10')
VALUES( '534211678','Caldarariu Ionel','5')
SELECT *
FROM DIRIGINTI
SELECT *
FROM ELEVI
SELECT nume
FROM DIRIGINTI
WHERE clasa='12A'
SELECT B.media_generala
FROM DIRIGINTI A, ELEVI B
WHERE:O zi buna va doresc
Problema13
CREATE TABLE MEMBRU (
id NUMBER(3) PRIMARY KEY,
nume VARCHAR2(25) NOT NULL,
prenume VARCHAR2(25) NOT NULL,
statut VARCHAR2(100)
);
drop Table Trupa
CREATE TABLE TRUPA (
idd NUMBER(3) PRIMARY KEY,
denumire VARCHAR2(25) NOT NULL,
an DATE NOT NULL,
nr_discuri NUMBER ,
observatii VARCHAR2(100)
);
select *
from MEMBRU
INSERT INTO MEMBRU (id, nume, prenume, statut)
VALUES (1, 'Popescu', 'Ion', 'solist'),
(2, 'Ionescu', 'Ana', 'chitarist'),
(3, 'Dragomir', 'Mihai', 'baterist'),
(4, 'Gheorghe', 'Maria', 'basist'),
(5, 'Radulescu', 'Andrei', 'solist');
INSERT INTO TRUPA (id, denumire, an, nr_discuri, observatii)
VALUES (1, 'Trupa A', 2022, 3, 'Trupa rock'),
(2, 'Trupa B', 2020, 2, 'Trupa pop'),
(3, 'Trupa C', 2023, 1, 'Trupa indie');
SELECT CONCAT(nume, ' ', prenume) AS "Nume si prenume"
FROM MEMBRU
WHERE statut = 'solist' OR statut = 'baterist';
SELECT [Link] AS "TRUPA", [Link] AS
"NUME_MEMBRU", [Link] AS "PRENUME_MEMBRU"
FROM TRUPA, MEMBRU
WHERE [Link] = [Link]
AND [Link] BETWEEN 2020 AND 2024
ORDER BY [Link], [Link], [Link];
Problema 16
CREATE TABLE PROFESOR (
id_profesor INT PRIMARY KEY,
nume VARCHAR(50),
prenume VARCHAR(50),
specialitate VARCHAR(50)
);
CREATE TABLE INCADRARE (
id_incadrare INT PRIMARY KEY,
id_profesor INT references PROFESOR(id_profesor),
clasa VARCHAR(10),
disciplina VARCHAR(50),
ore_saptamanal INT
);
INSERT INTO PROFESOR
VALUES (1, 'Popescu', 'Ion', 'Informatica')
INSERT INTO PROFESOR
VALUES (2, 'Ionescu', 'Maria', 'Matematica')
INSERT INTO PROFESOR
VALUES (3, 'Georgescu', 'Andrei', 'TIC')
INSERT INTO INCADRARE
VALUES (1, 1, '12A', 'Informatica', 5)
INSERT INTO INCADRARE
VALUES (2, 2, '12B', 'Matematica', 4)
INSERT INTO INCADRARE
VALUES (3, 3, '12A', 'TIC', 3)
INSERT INTO INCADRARE
VALUES (4, 1, '10A', 'Informatica', 4)
INSERT INTO INCADRARE
VALUES (5, 3, '11C', 'TIC', 2)
SELECT nume, prenume AS "Profesori"
FROM PROFESOR
WHERE specialitate IN ('Informatica', 'TIC')
SELECT [Link], [Link], B.ore_saptamanal AS "Ore",
[Link]
FROM PROFESOR A, INCADRARE B
WHERE [Link] LIKE '12A'
SELECT * from PROFESOR
Problema 19
CREATE TABLE VAMA (
id_vama NUMBER(5) PRIMARY KEY,
nume_vama VARCHAR2(25) NOT NULL,
judet VARCHAR2(25) NOT NULL
);
DESCRIBE VAMA
CREATE TABLE TRECERE (
id_trecere NUMBER(5) PRIMARY KEY,
nr_autoturism VARCHAR2(25) NOT NULL,
cond_auto VARCHAR2(25) NOT NULL,
nr_pers NUMBER(5) NOT NULL,
tip CHAR(1),
data_calendaristica DATE,
id_vama INT,
FOREIGN KEY (id_vama) REFERENCES VAMA(id_vama)
);
DESCRIBE TRECERE
INSERT INTO VAMA (nume_vama, judet) VALUES
('Moravița', 'Timiș'),
('Nădlac', 'Arad'),
('Borș', 'Bihor');
INSERT INTO TRECERE (nr_autoturism, cond_auto, nr_pers, tip,
data_calendaristica, id_vama)
VALUES
('SV69SSS', 'Ion Popescu', 2, 'I', '2011-05-15', 1),
('B 64 SIM', 'Maria Ionescu', 3, 'E', '2011-07-20', 1),
('SV 11 MSS', 'Vasile Georgescu', 1, 'I', '2022-10-10', 2),
('SV 55 RYO', 'Ana Popa', 4, 'I', '2023-03-01', 3)\;
SELECT DISTINCT cond_auto
FROM TRECERE
JOIN VAMA ON TRECERE.id_vama = VAMA.id_vama
WHERE VAMA.nume_vama = 'Moravița' AND
YEAR(TRECERE.data_calendaristica) = 2011;
SELECT VAMA.nume_vama, SUM(nr_pers) AS numar_persoane
FROM TRECERE
JOIN VAMA ON TRECERE.id_vama = VAMA.id_vama
GROUP BY VAMA.nume_vama;
Problema 22
CREATE TABLE CLADIRE (
id INT PRIMARY KEY,
nume VARCHAR(100),
adresa VARCHAR(100),
an_construire INT
);
CREATE TABLE APARTAMENT (
id INT PRIMARY KEY,
numar_camere INT,
suprafata NUMBER (8,2),
pret NUMBER(10,2),
situatie VARCHAR(20),
id_cladire INT,
FOREIGN KEY (id_cladire) REFERENCES CLADIRE(id)
);
SELECT * FROM CLADIRE;
SELECT * FROM APARTAMENT;
DESCRIBE CLADIRE;
DESCRIBE APARTAMENT;
INSERT INTO CLADIRE (id, nume, adresa, an_construire)
VALUES ('1', 'Cladire 1', 'Adresa 1', '2019');
INSERT INTO CLADIRE (id, nume, adresa, an_construire)
VALUES ('2', 'Cladire 2', 'Adresa 2', '2023');
INSERT INTO CLADIRE (id, nume, adresa, an_construire)
VALUES ('3', 'Cladire 3', 'Adresa 3', '2015');
INSERT INTO APARTAMENT (id, numar_camere, suprafata, pret,
situatie, id_cladire)
VALUES ('1', '2', '100', '90000', 'vandut', '1');
INSERT INTO APARTAMENT (id, numar_camere, suprafata, pret,
situatie, id_cladire)
VALUES ('2', '3', '125', '120000', 'vandut', '2');
INSERT INTO APARTAMENT (id, numar_camere, suprafata, pret,
situatie, id_cladire)
VALUES ('3', '3', '120', '130000', 'vandut', '3');
INSERT INTO APARTAMENT (id, numar_camere, suprafata, pret,
situatie, id_cladire)
VALUES ('4', '4', '150', '160000', 'vandut', '1');
b)
SELECT COUNT(*) AS numar_cladiri_2023
FROM CLADIRE
WHERE an_construire = 2023;
c)
SELECT [Link] AS "id_apartament", [Link] AS "pret_apartament",
[Link] AS "nume_cladire"
FROM APARTAMENT A, CLADIRE C
WHERE [Link] = (SELECT MAX (PRET) From APARTAMENT)
ORDER BY [Link] DESC
Problema 23
a)
CREATE TABLE Stapani (
cnp NUMBER(13) PRIMARY KEY,
nume VARCHAR2(30) NOT NULL,
adresa VARCHAR2(30) NOT NULL
);
CREATE TABLE Caini (
id NUMBER(10) PRIMARY KEY,
cnp NUMBER(13) REFERENCES Stapani(cnp) NOT NULL,
nume_caine VARCHAR2(30) NOT NULL,
premiu NUMBER(1) NOT NULL
);
INSERT INTO Stapani (cnp, nume, adresa) VALUES ('1960603143323', 'Popescu Marian',
'Strada Florilor Nr. 18')
INSERT INTO Stapani (cnp, nume, adresa) VALUES ('1960603148867', 'Iulian Marius',
'Strada Grivitei Nr. 68')
INSERT INTO Stapani (cnp, nume, adresa) VALUES ('1960603140379', 'Cauciuc Cristina',
'Strada Primaverii Nr. 1')
INSERT INTO Stapani (cnp, nume, adresa) VALUES ('1960603148121', 'Padurariu
Cosmina', 'Strada Morii Nr. 4')
INSERT INTO Stapani (cnp, nume, adresa) VALUES ('1960603140125', 'Andrei Ionut',
'Strada Plosnitelor Nr. 89')
INSERT INTO Caini (id, cnp, nume_caine, premiu) VALUES ('1', '1960603143323', 'sparky',
'1')
INSERT INTO Caini (id, cnp, nume_caine, premiu) VALUES ('2', '1960603143323', 'bobita',
'0')
INSERT INTO Caini (id, cnp, nume_caine, premiu) VALUES ('3', '1960603143323', 'steluta',
'3')
INSERT INTO Caini (id, cnp, nume_caine, premiu) VALUES ('4', '1960603148867', 'ursu',
'2')
INSERT INTO Caini (id, cnp, nume_caine, premiu) VALUES ('5', '1960603148867', 'lupu', '0')
INSERT INTO Caini (id, cnp, nume_caine, premiu) VALUES ('6', '1960603140379', 'dixi', '2')
INSERT INTO Caini (id, cnp, nume_caine, premiu) VALUES ('7', '1960603148121', 'buzz',
'1')
INSERT INTO Caini (id, cnp, nume_caine, premiu) VALUES ('8', '1960603148121', 'bella',
'2')
INSERT INTO Caini (id, cnp, nume_caine, premiu) VALUES ('9', '1960603140125', 'chapy',
'3')
INSERT INTO Caini (id, cnp, nume_caine, premiu) VALUES ('10', '1960603140125', 'dexter',
'0')
INSERT INTO Caini (id, cnp, nume_caine, premiu) VALUES ('11', '1960603140125', 'arcy',
'0')
b)
SELECT nume_caine AS "Caini cu premiul 1" FROM caini
WHERE premiu = 1
c)
SELECT B.nume_caine AS "Lista caini"
FROM stapani A, caini B
ORDER BY [Link] ASC and [Link] ASC
