推 tpdfes12000:感謝cutecpu大大幫忙,真的太感激了T^T,謝謝大大解答XD 10/06 15:07
推 PsMonkey:==.==== 這是作業吧.... 10/06 22:01
SELECT District,Brand,SUM(Dollar Sales Amount),SUM(Quantity Sold)
FROM Product Dimension as P,Daily Sales Fact as D,Store Dimension as S
WHERE P.Product Key = D.Product Key AND D.Store Key = S.Store Key
GROUP BY District,Brand
※ 引述《tpdfes12000 (even)》之銘言：
: http://i.imgur.com/HVPgQ.png
: 請問用一條指令就可以叫出圖上箭頭所指出的資料
: 課本都偏理論.....實在是沒有頭緒
: 不知哪位大大可以幫個忙,拜託各位大大了
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 210.59.164.109