Write a SQL query

SQL query :



Data model

Cities (idCity,Name)
Colors (idColor,Name)
Deliveries (idDelivery,#idProduct,#idFactory,#idSupplier,Date,Quantity)
Factories (idFactory,Name,#idCity)
Products (idProduct,Name,Weight,#idColor)
Suppliers (idSupplier,Name,#idCity)

Notice : weight is expressed in grams