here is some sample script to set up your data....you should always provide when asking questions such as this.

it helps us help you.

CREATE TABLE #yourtable(

insurer VARCHAR(4) NOT NULL

,claim_number INTEGER NOT NULL

,location VARCHAR(5) NOT NULL

,start_date DATETIME NOT NULL

,end_date DATETIME NOT NULL

);

INSERT INTO #yourtable(insurer,claim_number,location,start_date,end_date) VALUES ('john',5555,'east','1/5/10','1/17/10');

INSERT INTO #yourtable(insurer,claim_number,location,start_date,end_date) VALUES ('john',5555,'west','1/5/10','1/17/10');

INSERT INTO #yourtable(insurer,claim_number,location,start_date,end_date) VALUES ('john',5555,'south','1/5/10','1/17/10');

INSERT INTO #yourtable(insurer,claim_number,location,start_date,end_date) VALUES ('jane',3333,'west','4/6/12','4/16/12');

INSERT INTO #yourtable(insurer,claim_number,location,start_date,end_date) VALUES ('jane',3333,'north','4/6/12','4/16/12');

INSERT INTO #yourtable(insurer,claim_number,location,start_date,end_date) VALUES ('jane',3333,'east','4/6/12','4/16/12');

select * from #yourtable

please read

http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

ps...this looks like homework...can you post what you have tried so far.