Дополнить созданный запрос

CREATE TABLE number_postavchiki
(
number_postavchik  INT                
lastname           nVarchar(100), 
rating       FLOAT, 
city              nvarchar(100)
)
 
CREATE TABLE #ДЕТАЛИ
(
number_tools      INT                 
name_tools            nVarchar(100), 
colour              nvarchar(100), 
weight                 FLOAT, 
city               nvarchar(100)
)
 
CREATE TABLE product(
number_product     INT                 
name_product            nVarchar(100), 
city             nvarchar(100)
)
 
CREATE TABLE  delivery
(
number_postavchiki  INT                 
number_tools      INT                
number_product     INT                
amount         INT
)

select lastname, rating, city from postavchiki
join
(select number_postavchik, number_product, amount from delivery) postav
on
postav.number_postavchik = postavchiki.number_postavchik
join
on
(select delivery.number_postavchik as postavchik, delivery.number_product as Prod1, delivery.amount, sum(amount)/2 as sum_pol from delivery group by Prod1) summ
on
postav.amount > summ.sum_pol and postav.number_product = summ.Prod1;

select t1.number_tools as numb1, t1.name_tools as name1, 
t2.number_tools as numb2, t2.name_tools as name2, 
t1.colour as t_colour, product.city 
from tools as t1, tools as t2, product 
where t1.number_tools <> t2.number_tools and 
t1.colour = t2.colour and 
t1.city <> t2.city;