question

naveaelizabeth avatar image
naveaelizabeth asked

Write a query to produce a report that looks like the example table below for Feb 2015

Country codes for the US, UK and DE are US UK and DE respectively. Date # Customers Revenue US Revenue UK Revenue DE Revenue Other Revenue All 2/1/2015 8 476 $11 245 $7 839 $2 098 $6 707 $27 889 2/2/2015 . . . . . . . 2/28/2015 . . . . . .
date
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
homework?
0 Likes 0 ·

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered
[PIVOT][1] [1]: https://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image David Wimbush commented ·
Now that's what I call an answer! +1
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.