天池训练营-Mysql-task06

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

SELECT 
IS.TICKER_SYMBOL,
IS.END_DATE,
IS.T_REVENUE,
IS.T_COGS,
IS.N_INCOME,
MD.TICKER_SYMBOL,
MD.END_DATE,
MD.CLOSE_PRICE,
CO.TICKER_SYMBOL,
CO.INDIC_NAME_EN,
CO.END_DATE,
CO.VALUE 
FROM `income statement` AS `IS`
INNER JOIN	`Market Data` AS MD 
ON IS.TICKER_SYMBOL=MD.TICKER_SYMBOL 
INNER JOIN `Company Operating` AS CO 
ON	IS.TICKER_SYMBOL=CO.TICKER_SYMBOL 
WHERE IS.TICKER_SYMBOL IN (600383,600048);

练习题2：

SELECT *,
DENSE_RANK() OVER (ORDER BY `citric acid` ) 
FROM `winequality-red` 
WHERE `pH`=3.03;

练习题3：
发放优惠券张数最多的商家

SELECT
	t1.Merchant_id,
	COUNT( t1.Discount_rate ) AS count
FROM
	( SELECT * FROM ccf_offline_stage1_test_revised WHERE Date_received BETWEEN "2016-07-01" AND "2016-07-31" GROUP BY Merchant_id ) AS t1
	ORDER BY count LIMIT 1;