i need help with this question:

Question #2 - 10 points

The marketing team wants a list of all the products for all customers that they can include in an email. You'll need information from the StockItems and Colors tables in the Warehouse schema, and the Suppliers table in the Purchasing schema. Include the Stock Item ID, name, Color, brand, size, lead time, unit price, and Supplier Name. For things that do not have a color, use "unknown" as the return value.

Sort the final results by supplier, unit price (lowest to highest) and Stock Item name.

This query will return 227 rows. 99 items will have an unknown color . this is the schema below . and the table names are : Warehouse.StockItems , Purchasing.Suppliers and Warehouse.Colors.

Colors Archive (Warehouse) ColorID Colors Archive Warehouse) ColorName LastEdited By ValidFrom ValidTo StockItems Archive (Warehouse) StockItemID StockitemName SupplierlD ColorID UnitPackagels OuterPackageld Brand Size Lead Time Days QuantityPerOuter IsChillerStock Barcode TaxRate UnitPrice Recommended RetailPrice TypicalWeightPerUnit Marketing Comments InternalComments Photo CustomFields Tags SearchDetails LastEdited By ValidFrom ValidTo Suppliers Archive (Purchasing) Supplier SupplierName SupplierCategoryID PrimaryContact PersonlD AlternateContact PersonlD DeliveryMethodID DeliveryCityID PostalCityID Supplier Reference BankAccountName BankAccount Branch BankAccountCode BankAccount Number BankinternationalCode PaymentDays InternalComments PhoneNumber FaxNumber WebsiteURL Delivery AddressLine1 DeliveryAddressLine2 Delivery PostalCode Delivery Location PostalAddressLine1 Postal AddressLine2 Postal PostalCode LastEdited By ValidFrom ValidTo