--USE NORTHWND

--zad1
/*CREATE procedure OrderDates
@od data,
@do data
AS
Select * from Orders Where OrderDate >=@od
AND OrderDate<=@do

EXEC OrderDates '1996-07-01', '1996-07-10';
*/

-- zad2

/*Create procedure zamowienia2
@wartosc int,
@countryText VARCHAR(15)
AS
Select *
From Customers
where country like @countryText AND @wartosc*/

--exec zamowienia2 10,'USA';

--zad3

/*create trigger drukuj on Products
after insert 
as select *
from inserted*/

--zad4 
/*create procedure Rabat2
@val int,
@disc_value float
AS
update [Order Details] 
set Discount = @disc_value 
where Quantity*UnitPrice>@val*/

--exec Rabat 1000, 0.4;

--zad5
/*alter table orders ADD LastModified date;
alter trigger trig2 on [Order Details] after insert, update, delete
as
update orders set LastModified = GETDATE() where OrderID in (select OrderID from inserted) or ...
insert into[Order Details](OrderID,ProductID) values(10248,41);
select orderID, LastModified from Orders where LastModified is not null;*/



--zad6

create trigger zad666
on customers 
after insert
	as
	select *
	from products p
	join [Order Details]d
	on p.ProductID  = d.ProductID
	join orders o
	on o.OrderID = d.OrderID
	join customers c
	on o.CustomerID = c.CustomerID