SQL训练营：SQL综合练习题

本笔记为阿里云天池龙珠计划SQL训练营的学习内容，链接为：https://tianchi.aliyun.com/specials/promotion/aicampsql 

Part1：学习知识点概要

本笔记主要是MYSQL的综合练习题。

Part2：学习内容

下面是Task6练习题的代码部分，重复的方法类似的题目未被贴出。

题目1：

SELECT  P1.*,
        P2.T_REVENUE, P2. T_COGS, P2. N_INCOME,
        P3.INDIC_NAME_EN, P3.END_DATE
FROM(SELECT TICKER_SYMBOL, END_DATE, CLOSE_PRICE
	 FROM tianchi_test.`market data`
     WHERE TICKER_SYMBOL= 600383 OR TICKER_SYMBOL=600048) AS P1
LEFT JOIN( SELECT TICKER_SYMBOL, END_DATE, T_REVENUE, T_COGS, N_INCOME
		   FROM tianchi_test.`income statement`
		   WHERE TICKER_SYMBOL= 600383 OR TICKER_SYMBOL=600048) AS P2
ON P1. TICKER_SYMBOL = P2. TICKER_SYMBOL 
AND P1. END_DATE = P2.END_DATE
LEFT JOIN( SELECT TICKER_SYMBOL, INDIC_NAME_EN, END_DATE, VALUE
           FROM tianchi_test.`company operating`
           WHERE TICKER_SYMBOL= 600383 OR TICKER_SYMBOL=600