Software environment: MySQL 8.0, MySQL Workbench 8.0
Some information may be treated as confidential, so that they have been concealed.
1. Calculating daily hot queries and producing indicators of trends developing
代码
结果-数值打码了
2. Checking the dates the GMV of which higher than a specific number to see whether the peaks have come
代码
结果
3. Getting the top3/top10 GMV-producing queries to guide marketing operation
代码
结果
4. Computing the median of GMV of categories
代码
结果-仅展示小数位数
5. Labeling queries with sexuality prediction and getting top5% queries from all labels according to the frequency of the queries
num：分类计数， percentage：num/分类count
结果-查询词和gmv打了马赛克
6. Calculating query-retetion-rate
代码
结果（截取部分）
