StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8901094
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
5
CommunityOwnedDate
CreationDate
2012-01-17T20:13:09.503
FavoriteCount
0
LastActivityDate
2012-01-17T21:55:59.297
LastEditDate
2012-01-17T21:55:59.297
LastEditorUserId
1058763
OwnerUserId
1058763
ParentId
8900848
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
I tested the SQL(T-SQL in SQL Server) below. It returns 11.5876 as grand_total. Is this okay for you? <pre><code>create table #raw_financials ( title varchar(20) ,partner_share_currency varchar(20) ,us_earnings_usd decimal(15, 5) ,cad_earnings_cad decimal(15, 5) ,date datetime ) insert into #raw_financials values ('Gamers', 'USD', 3.25, 0, '2012-12-01') insert into #raw_financials values ('Gamers', 'CAD', 0, 4, '2012-12-01') insert into #raw_financials values ('Gamers', 'USD', 4.5, 0, '2012-12-01') create table #exchange_rates ( currency varchar(20) ,conversion_to_usd decimal(15, 5) ,date datetime ) insert into #exchange_rates values ('CAD', 0.95940, '2012-12-01') insert into #exchange_rates values ('USD', 1, '2012-12-01') SELECT rf.title, --partner_share_currency, SUM((rf.us_earnings_usd + rf.cad_earnings_cad) * er.conversion_to_usd) AS grand_total FROM #raw_financials rf INNER JOIN #exchange_rates er ON er.currency = rf.partner_share_currency AND er.date = rf.date WHERE rf.title LIKE '%Gamers%' AND rf.date='2012-12-01' GROUP BY rf.title </code></pre> But I have never used MySQL, so the result might be different. Update: Here is another query for GBP and SEK. It returns 14.81396 in my T-SQL: <pre><code>create table #raw_financials ( title varchar(20) ,partner_share_currency varchar(20) ,us_earnings_usd decimal(15, 5) ,cad_earnings_cad decimal(15, 5) ,uk_earnings_gbp decimal(15, 5) ,swedish_earnings_skk decimal(15, 5) ,date datetime ) insert into #raw_financials values ('Gamers', 'USD', 3.25, 0, 0, 0, '2012-12-01') insert into #raw_financials values ('Gamers', 'CAD', 0, 4, 0, 0, '2012-12-01') insert into #raw_financials values ('Gamers', 'USD', 4.5, 0, 0, 0, '2012-12-01') insert into #raw_financials values ('Gamers', 'GBP', 0, 0, 2, 0, '2012-12-01') insert into #raw_financials values ('Gamers', 'SEK', 0, 0, 0, 1, '2012-12-01') create table #exchange_rates ( currency varchar(20) ,conversion_to_usd decimal(15, 5) ,date datetime ) insert into #exchange_rates values ('CAD', 0.95940, '2012-12-01') insert into #exchange_rates values ('USD', 1, '2012-12-01') insert into #exchange_rates values ('GBP', 1.54223, '2012-12-01') insert into #exchange_rates values ('SEK', 0.14190, '2012-12-01') SELECT rf.title, SUM((rf.us_earnings_usd + rf.cad_earnings_cad + rf.uk_earnings_gbp + rf.swedish_earnings_skk ) * er.conversion_to_usd) AS grand_total FROM #raw_financials rf INNER JOIN #exchange_rates er ON er.currency = rf.partner_share_currency AND er.date = rf.date WHERE rf.title LIKE '%Gamers%' AND rf.date='2012-12-01' GROUP BY rf.title </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POSumming sales across different currencies in SQL
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USJunichi Ito
UserOwnerUserId
1. USJunichi Ito
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.