task6

SELECT MarketData.*, OperatingData.INDIC_NAME_EN, OperatingData.VALUE, IncomeStatement.N_INCOME, IncomeStatement.T_COGS, IncomeStatement.T_REVENUE FROM ( SELECT TICKER_SYMBOL, END_DATE, CLOSE_PRICE FROM `market data` WHERE TICKER_SYMBOL IN ('600383','600048') ) MarketData LEFT JOIN -- operating data (SELECT TICKER_SYMBOL, INDIC_NAME_EN,END_DATE, VALUE FROM `company operating` WHERE TICKER_SYMBOL IN ('600383','600048') ) OperatingData ON MarketData.TICKER_SYMBOL = OperatingData.TICKER_SYMBOL AND MarketData.END_DATE = OperatingData.END_DATE LEFT JOIN -- income statement (SELECT DISTINCT TICKER_SYMBOL, END_DATE, T_REVENUE, T_COGS, N_INCOME FROM `income statement` WHERE TICKER_SYMBOL IN ('600383','600048') ) IncomeStatement ON MarketData.TICKER_SYMBOL = IncomeStatement.TICKER_SYMBOL AND MarketData.END_DATE = IncomeStatement.END_DATE ORDER BY MarketData.TICKER_SYMBOL, MarketData.END_DATE