Computer Science Homework Solutions
Problem
#100979

Sql Server 2005 Express

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.  

See attached file for full problem description.

Attached file(s):
Attachments
View SQL Server 2005.doc  View File

Attachment Content Summary (Note: view attachment at the above link before purchasing. Actual attachment content may vary slightly from that shown below.)

View SQL Server 2005.doc
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.
Solution
What is this?
By OTA - Overall OTA Rating
Purchase Cost Now
$2.19 CAD (was ~$7.98)
Included in Download
  • Plain text response
  • Attached file(s):
    • View+SQL+Server+2005[1].doc
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
Browse