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

 Запрос: Выдать список поставщиков и товаров, которые они поставили, изменение цен которых превысило на 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;