Discussion:
Q: 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.
|
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
|