我的教授告诉我,我的输出对于我必须创建的这个查询是不正确的。有谁能指出原因吗?也许他想要不同的查询方式?我认为这个问题很简单。ERD、问题、查询和输出如下所示。任何帮助都是非常感谢的。谢谢
输出:
88 TM Toyota Motors NYSE 50300 4099128.08 $
28 TM Toyota Motors NYSE 50300 4099128.08 $
88 TYO:6201 Toyota Motors NYSE 50300 4099128.08 $
28 TYO:6201 Toyota Motors NYSE 50300 4099128.08 $
71 NYT The New York Times NYSE 84000 1046892 $
11 NYT The New York Times NYSE 84000 1046892 $
78 BA British Airways LSE 72000 14711256 £
18 BA British Airways LSE 72000 14711256 £
SELECT
trade.trade_id,
stock_listing.stock_symbol,
company.name company_name,
stock_exchange.symbol AS stock_exchange_symbol,
trade.shares AS number_of_shares_traded,
trade.price_total,
currency.symbol currency_symbol
FROM trade
JOIN stock_listing
ON stock_listing.stock_id = trade.stock_id
JOIN company
ON company.stock_id = trade.stock_id
JOIN stock_exchange
ON stock_exchange.stock_ex_id = trade.stock_ex_id
JOIN currency
ON currency.currency_id = company.currency_id
WHERE trade.shares > 50000;
发布于 2019-05-23 05:04:36
我注意到您在多个记录中具有相同的交易ID。也就是说,看起来多个记录可以被认为是“交易”。如果是这样,首先按交易ID分组,然后查找计数> 50,000。
https://stackoverflow.com/questions/56264825
复制相似问题