SQL Server 2019

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

CREATE TABLE Reports
    ([Report_Id] int, [Report_name] varchar(8))
;
    
INSERT INTO Reports
    ([Report_Id], [Report_name])
VALUES
    (1, 'Income'),
    (2, 'Outcomes'),
    (3, 'Costs')
;

CREATE TABLE ReportsIpRel
    ([Ip_Id] int, [Report_Id] int)
;
    
INSERT INTO ReportsIpRel
    ([Ip_Id], [Report_Id])
VALUES
    (6, 1),
    (4, 2),
    (5, 2),
    (2, 2),
    (1, 3)
;

CREATE TABLE InfoProviders
    ([Ip_Id] int, [Ip_Name] varchar(9))
;
    
INSERT INTO InfoProviders
    ([Ip_Id], [Ip_Name])
VALUES
    (6, 'Comission'),
    (4, 'Comapny'),
    (5, 'Others'),
    (2, 'People'),
    (1, 'Traveler')
;

CREATE TABLE QueriesIpRel
    ([Ip_Id] int, [Query_Id] int)
;
    
INSERT INTO QueriesIpRel
    ([Ip_Id], [Query_Id])
VALUES
    (6, 3),
    (4, 3),
    (5, 3),
    (2, 5),
    (1, 1)
;

CREATE TABLE Queries
    ([uery_Id] int, [Query_Name] varchar(10))
;
    
INSERT INTO Queries
    ([uery_Id], [Query_Name])
VALUES
    (1, 'connection'),
    (2, 'distantcon'),
    (3, 'shortconn'),
    (4, 'linking'),
    (5, 'grounding')
;

23 rows affected

Report_Id	Report_name	ip_id	Ip_Name	uery_Id	Query_Name
2	Outcomes	4	Comapny	3	shortconn
2	Outcomes	5	Others	3	shortconn
2	Outcomes	2	People	5	grounding