How to perform for this Sql Server Query

In advertisement company, how several persons apply specific advertisement type specific state how will accomplish for this probe
I required output this
Advertisement State Apply supporter
U.A.E Paper Dubai count here
Walking abu Dhabi
News Sharjha
Friends ajman
here how many members in Dubai for
advertisement U.A.E paper, walking, news, friends separately count in each state
individually count I mention below query

create table advlist
aid int primary key identity(1,1),
aname nvarchar(100)

insert into advlist values (‘Dubai’),(‘Walking’),(‘News’),(‘Friends’)

create table advstate
stid int primary key identity(1,1),
stname nvarchar(100)

insert into advstate values (‘Dubai’),(‘abu Dhabi’),(‘Sharjha’),(‘Ajman’)

create table advapply
apid int primary key identity(1,1),
apname nvarchar(100),
apmemberid int,
aid int
insert into advapply values (‘John-A’,1,1),(‘Rufals-A’,2,1),(‘Watson-A’,1,2),(‘morries-A’,1,3)

create table advpersonal
apeid int primary key identity(1,1),
apemember nvarchar(50),
stid int

insert into advpersonal values (‘John’,1),(‘Rufals’,2),(‘Watson’,1),(‘morries’,1)

Is there any software developer who can guide me in it!

Add Comment
  • 0 Answer(s)
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.