微信扫码
与创始人交个朋友
-- 订单表
CREATE TABLE orders ( order_id INT PRIMARY KEY, product_name VARCHAR(255), order_date DATE, quantity INT );
SELECT SUM(quantity) AS total_orders
FROM orders WHERE product_name = 'xx产品' AND order_date >= CURDATE() - INTERVAL 7 DAY;
SELECT SUM(quantity) AS total_sales FROM orders
WHERE product_name = 'xx产品' AND YEAR(order_date) = YEAR(CURDATE());
-- 国内销售表
CREATE TABLE domestic_sales ( product_name VARCHAR(255), sales_count INT );
-- 国外销售表
CREATE TABLE international_sales ( product_name VARCHAR(255), sales_count INT );
SELECT SUM(ds.sales_count) AS domestic_sales, SUM(is.sales_count) AS international_sales
FROM domestic_sales ds, international_sales is
WHERE ds.product_name = 'xx品牌' AND is.product_name = 'xx品牌';
WITH sales_data AS ( SELECT product_name, SUM(quantity) AS total_sales
FROM orders WHERE product_name = 'xx品牌'
AND order_date >= CURDATE() - INTERVAL 3 MONTH GROUP BY product_name ),
ranked_sales AS ( SELECT product_name, total_sales, RANK() OVER (ORDER BY total_sales DESC) AS sales_rank FROM sales_data )
SELECT product_name, total_sales / 3 AS avg_monthly_sales
FROM ranked_sales WHERE sales_rank = 1;
-- 假设有一张效率表
CREATE TABLE efficiency ( region VARCHAR(255), product_name VARCHAR(255), efficiency_value DECIMAL(10,2), month DATE );
-- 查询效率环比下降的原因
WITH current_month AS ( SELECT efficiency_value FROM efficiency
WHERE region = '华北' AND product_name = 'xx' AND month = CURDATE() - INTERVAL 1 MONTH ),
previous_month AS ( SELECT efficiency_value FROM efficiency WHERE region = '华北'
AND product_name = 'xx' AND month = CURDATE() - INTERVAL 2 MONTH )
SELECT cm.efficiency_value - pm.efficiency_value AS efficiency_drop
FROM current_month cm, previous_month pm;
53AI,大模型落地应用首选服务商
定位:开箱即用的大模型落地应用平台
承诺:先做场景POC验证,看到效果再签署服务协议。零风险落地应用大模型,已交付160+中大型企业
如果你看见AI对商业世界的变革,欢迎来和我们一起探索~
2024-07-03
让企业为大模型买单,目前有四大难
2024-07-03
Laplace AI Lab打破了传统SaaS和RPA框架的局限,解决了功能繁杂、操作复杂
2024-07-03
演讲实录|如何以 AI+指标平台构建企业数智竞争力
2024-07-03
演讲实录丨智能一站式指标平台在头部企业的实践分享
2024-07-03
“指标平台”掀起数智风暴:AI 对话已达 95% 准确率、100% 可解释!
2024-07-03
不是“尝鲜”,餐饮巨头市场团队已用指标平台+AI 更高效理解业务和决策
2024-07-03
GenAI大模型成熟度模型 - Google
2024-07-02
从企业内部的聊天记录中构建一个知识库式的检索增强生成 (RAG) 应用
2024-03-11
2024-04-02
2024-03-11
2024-04-24
2024-04-01
2024-04-18
2024-04-06
2024-04-08
2024-05-15
2024-04-03
2024-07-01
2024-06-29
2024-06-28
2024-06-24
2024-06-21
2024-06-20
2024-06-20
2024-06-19