CREATE TABLE Company (
    Id INT PRIMARY KEY,
    Name TEXT
);

INSERT INTO Company
VALUES
    (1, 'Mindbox'),
    (2, 'Ozon'),
    (3, 'Bosch'),
    (4, 'Tesla');

CREATE TABLE Activity (
    Id INT PRIMARY KEY,
    Name TEXT
);

INSERT INTO Activity
VALUES
    (1, 'IT'),
    (2, 'Market'),
    (3, 'Car'),
    (4, 'Building');

CREATE TABLE CompanyActivity (
    CompanyId INT,
    ActivityId INT,
    PRIMARY KEY (CompanyId, ActivityId),
    FOREIGN KEY (CompanyId) REFERENCES Company(Id),
    FOREIGN KEY (ActivityId) REFERENCES Activity(Id)
);

INSERT INTO CompanyActivity
VALUES
    (1, 1),
    (2, 1),
    (2, 2),
    (4, 3);

SELECT
    Company.Name AS CompanyName,
    Activity.Name AS ActivityName
FROM Company
LEFT JOIN CompanyActivity
    ON Company.Id = CompanyActivity.CompanyId
LEFT JOIN Activity
    ON CompanyActivity.ActivityId = Activity.Id;