Выполнение sql запросов

Выполнить запросы на основе созданных таблиц

1) Выдать список покупателей, информацию о купленных товарах с указанием поставщиков и общей нечистой прибыли.

2) Выдать список поставщиков и товаров, которые они поставили, изменение цен которых превысило на 5%

USE bd_stock

GO

CREATE TABLE ProductsInStock(

 ID_product INT NOT NULL PRIMARY KEY,

 Сategory NVARCHAR(100) NOT NULL,

 Name NVARCHAR(100) NOT NULL,

 Quantity INT NOT NULL CHECK (Quantity>=0)

 )

GO

CREATE TABLE Suppliers(

 ID_supplier INT NOT NULL PRIMARY KEY,

 Firm_name NVARCHAR(100) NOT NULL,

 Address NVARCHAR(50) NOT NULL,

 )

GO

CREATE TABLE Information_about_deliveries(

 Quantity INT NOT NULL CHECK (Quantity>0),

 Total_cost MONEY NOT NULL CHECK (Total_cost>0),

 ID_supplier INT NOT NULL,

 ID_product INT NOT NULL,

 FOREIGN KEY (ID_supplier) REFERENCES Suppliers (ID_supplier),

 FOREIGN KEY (ID_product) REFERENCES ProductsInStock (ID_product),

)

GO

CREATE TABLE Buyers(

 ID_buyer INT NOT NULL PRIMARY KEY,

 Firm_name NVARCHAR(100) NOT NULL,

 Address NVARCHAR(50) NOT NULL

)

GO

CREATE TABLE Contract(

 ID_contract INT NOT NULL PRIMARY KEY,

 Total_cost MONEY NOT NULL CHECK (Total_cost>0),

 ID_buyer INT NOT NULL,

 FOREIGN KEY (ID_buyer) REFERENCES Buyers (ID_buyer),

)

GO

CREATE TABLE Products_in_contract(

 Quantity INT NOT NULL CHECK (Quantity>=0),

 ID_product INT NOT NULL,

 ID_contract INT NOT NULL,

 ID_buyer INT NOT NULL

 FOREIGN KEY (ID_product) REFERENCES ProductsInStock (ID_product),

 FOREIGN KEY (ID_contract) REFERENCES Contract (ID_contract),

 FOREIGN KEY (ID_buyer) REFERENCES Buyers (ID_buyer),

)

GO

CREATE TABLE Price_product(

 ID_price INT NOT NULL PRIMARY KEY,

 Price_product MONEY NOT NULL CHECK (Price_product>0),

 Date_of_update DATE NOT NULL CHECK (Date_of_update<=GETDATE()),

 ID_product INT NOT NULL,

 FOREIGN KEY (ID_product) REFERENCES ProductsInStock (ID_product),

)

GO

SELECT * FROM ProductsInStock;

SELECT * FROM Suppliers;

SELECT * FROM Information_about_deliveries;

SELECT * FROM Buyers;

SELECT * FROM Contract;

SELECT * FROM Products_in_contract;

SELECT * FROM Price_product;