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.
