学到很多丨如何取多个单独的数据再拼接起来

解决的方法就是通过写多个临时表来解决如下:

多个临时表之间用逗号隔开就行了，记得带相同的主键以用来拼接

group by 1的意思是group by select后面的第1个字段

with a AS(
SELECT 
style_id,
SUM(inventory)'inventorytotal',
SUM(tag_price*inventory)'inventorymoney'
FROM product_tb
GROUP BY 1) ,

b AS(
SELECT
style_id,
SUM(sales_num)'sales_numtotal',
SUM(sales_price)'gmv'
FROM product_tb
JOIN sales_tb USING (item_id)
GROUP BY 1)


SELECT
style_id,
ROUND(sales_numtotal/(inventorytotal-sales_numtotal)*100,2)'pin_rate(%)',
ROUND(gmv/inventorymoney*100,2)'sell-through_rate(%)'
FROM a JOIN b USING(style_id)
GROUP BY 1