爱喝胡辣汤

分类

/ 注册

全部文章（共45篇）

题解 | #插入记录（二）#

insert into exam_record_before_2021 ( select null, uid, exam_id, start_time, s...

2023-07-04

0 269

题解 | #确定最佳顾客的另一种方式（二）#

-- 三表连结inner join写法 select cust_name, sum(item_price * quantity) total_price from OrderItems inner join Orders on OrderItems.order_num...

2023-07-03

0 134

题解 | #买prod_id为BR01的所有顾客电子邮件#

select cust_email from OrderItems inner join Orders on OrderItems.order_num = Orders.order_num inner join Customers on Customers.cust_id = Orders.cus...

2023-07-03

0 173

题解 | #确定哪些订单购买prod_id为BR01的产品#

select cust_id, order_date from OrderItems, Orders where OrderItems.order_num = Orders.order_num and prod_id = 'BR01' order by...

2023-07-03

0 174

题解 | #返回顾客名称和相关订单号以及每个订单的总价#

-- 三表联结：等联结法 select cust_name,order_num,sum(quantity*item_price) as OrderTotal from( select Customers.cust_name cust_name, OrderItems.* fr...

2023-07-03

0 147

题解 | #返回顾客名称和相关订单号#

# inner join法 # select cust_name,order_num from Customers # inner join Orders # on Customers.cust_id = Orders.cust_id # order by cust_name,order_num ...

2023-07-03

0 166

题解 | #从Products检索所有产品名称和对应销售数#

select prod_name, sum(quantity) quant_sold from Products left join OrderItems on Products.prod_id = OrderItems.prod_id group by p...

2023-07-03

0 158

题解 | #返回每个顾客不同订单的总金额#

select cust_id,sum(item_price*quantity) total_ordered from( select OrderItems.order_num as OIon, item_price, quantity, cust_id from ...

2023-07-03

0 160

题解 | #对顾客ID和日期排序#

select -- 从所有列中过滤出两列 cust_id, order_num from ( select * from Orders order by ...

2023-07-02

0 186

题解 | #日活与每日次日留存率#

SELECT visit_date,dau,next_day_per FROM( -- 日活 SELECT visit_date, COUNT(id) dau FROM user_visit_log GROUP BY visit_date) t2 , -- 两表连接 ...

2023-07-01

0 210