Pana la ex 7, inclusiv, Sql Server

Pana la ex 7, inclusiv

create table Produs(
    idprodus integer, 
    denumire varchar(100), 
    pret integer, 
    furnizor varchar(20),
    primary key (idprodus));
        insert into Produs(idprodus, Denumire, Pret, Furnizor) values
        (111, 'Duster', 10000, 'Dacia'), 
        (112, 'BMW', 10001, 'Seria 3'), 
        (113, 'Audi', 80, 'Seria 1'),
        (114, 'Lemne', 45, 'Trei_Brazi_SRL');
DELETE FROM Produs WHERE pret >= 100;
update Produs
set Pret = Pret + (pret * 1/10)
where Furnizor = 'Trei_Brazi_SRL'; 
select * from Produs;

create table Vanzare(
    idvanzare integer, 
    idclient integer NOT NULL, 
    idprodus integer NOT NULL, 
    cantitate integer NOT NULL,
    primary key (idvanzare));
    insert into Vanzare(idvanzare, idclient, idprodus, cantitate) values(11, 112, 1, 2);
    ALTER TABLE Vanzare
DROP COLUMN cantitate;
select * from Vanzare;

create table Client(
    idclient integer,
    nume varchar(100) NOT NULL,
    prenume varchar(100) NOT NULL ,
    judet varchar(20) NOT NULL,
    telefon varchar(20) NOT NULL,
    adresa varchar(20),
    primary key (idclient));
insert into Client(idclient, nume, prenume, judet, telefon) values
(112, 'Ba', 'KA', 'Japonia', '07070707'),
(113, 'B', 'K', 'China', '24059587234'),
(114, 'C', 'KA', 'Korea', '1231237');
select * from Client;


run \| edit \| history \| help	0