MySQL 8.0

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

CREATE TABLE Producer (
  `producerID` INTEGER,
  `producerName` VARCHAR(9),
  `type` VARCHAR(6),
  `lat` FLOAT
);

INSERT INTO Producer
  (`producerID`, `producerName`, `type`, `lat`)
VALUES
  ('123', 'ToysRUs', 'Retail', '52.445'),
  ('124', 'Toys R Us', 'Online', '52.445'),
  ('234', 'GameStop', 'Retail', '55.150'),
  ('345', 'Amazon', 'Online', '56.110');
DELETE p1
FROM Producer p1 INNER JOIN Producer p2 
ON p2.lat = p1.lat 
WHERE p1.type = 'Retail' AND p2.type <> p1.type;
SELECT * FROM Producer;


producerID
producerName
type
lat


124
Toys R Us
Online
52.445

234
GameStop
Retail
55.15

345
Amazon
Online
56.11

producerID	producerName	type	lat
124	Toys R Us	Online	52.445
234	GameStop	Retail	55.15
345	Amazon	Online	56.11