Transact-SQL using for SQL Server

create a table simple tableperson
 create table person
(
    p_id  int,
    firstname varchar(50),
     lastname varchar(50),
    address varchar(70),
    city  char(20)
)
select * from person
insert into person values (1,'saikat','ghosh','india','kolkata')
insert into person values (2,'ayon','dash','india','kolkata')
insert into person values (3,'anupom','saha','india','dunlop')
insert into person values (4,'saikat','dash','india','belghoria')
insert into person values (5,'saikat','ghosh','india','kolkata')