I am having trouble creating A View in SQL Server 2005 using the following table. I have selected subscriber_id and magazine_id, but I cannot create the correct code to complete the view. Please see below. Any help would be appreciated
|
subscriber_id
|
Magazine_id
|
Start_date
|
|
C2
|
S1
|
10/1/2005
|
|
C2
|
S3
|
1/1/2006
|
|
C1
|
S2
|
2/15/2005
|
|
C3
|
S2
|
6/1/2005
|
|
C4
|
S2
|
11/15/2004
|
|
C6
|
S3
|
10/15/2005
|
|
C5
|
S1
|
4/15/2005
|
|
C7
|
S1
|
8/1/2005
|
|
C7
|
S2
|
2/1/2006
|
|
C5
|
S3
|
11/15/2004
|
|
C4
|
S1
|
1/4/2005
|
Create a view with the table which shows the number of subscribers who received each type of magazine. The view should have columns for the magazine ID and count.