MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table Contacts (
    CustomerID integer primary key,
    FullName text,
    MarketID text
);

create table Order_ (
    OrderID integer primary key,
    CustomerID integer,
    OrderDate date,
    foreign key (CustomerID) references Contacts(CustomerID)
);

create table Product (
    ProductCode integer primary key,
    Brand text,
    ProductName text
);

create table OrderedItems (
    OrderedItemID integer primary key,
    OrderID integer not NULL,
    ProductCode integer not NULL,
    InvoicePrice integer,
    foreign key (ProductCode) references Product(ProductCode),
    foreign key (OrderID) references Order_(OrderID)
);

insert into Contacts values(1, "John", "MarketA");
insert into Contacts values(2, "Jack", "MarketA");
insert into Contacts values(3, "George", "MarketB");
insert into Contacts values(4, "Karen", "MarketC");
insert into Contacts values(5, "Lucy", "MarketB");

insert into Product values(1, "Western Digital", "Hard drive 1TB");
insert into Product values(2, "Samsung", "Monitor 27");
insert into Product values(3, "nVidia", "GPU 8GB");

insert into Order_ values(1, 1, "2020-1-1"); -- John's
insert into Order_ values(2, 1, "2020-1-2"); -- John's
insert into Order_ values(3, 1, "2021-1-2"); -- John's
insert into Order_ values(4, 5, "2020-1-1"); -- Lucy's
insert into Order_ values(5, 4, "2020-1-1"); -- Karen's

insert into OrderedItems values(1, 1, 1, 1000); -- John's 1st order, 1st item
insert into OrderedItems values(2, 1, 1, 1000); -- John's 1st order, 2nd item
insert into OrderedItems values(3, 2, 2, 300); -- John's 2nd order, 1st item
insert into OrderedItems values(4, 4, 1, 1000); -- Lucy's 1st order, 1st item

MarketId	ProductName	TotalSales
MarketA	Hard drive 1TB	2000
MarketB	Hard drive 1TB	1000