select * from autoparts where ap_name='挡风玻璃'; |
select * from shopping_order where oid=1 |
select * from autoparts where is_sale=1 and price<1000; |
select distinct(comment.client_cid) as 用户ID from comment left join autoparts on comment.autoparts_apid = autoparts.ap_id; |
select c_id,year(create_time) from client group by year(create_time), c_id; |
select * from autoparts where second_class_scid=1 order by ap_id desc |
select * from client group by year(now()),c_name order by c_name; |
select client_cid 用户ID, SUM(total_price) 总价 from shopping_order group by client_cid; |
select a.ap_name 商品名称,sum(oha.number) 商品数量 from autoparts a left join order_has_autoparts oha on a.ap_id = oha.autoparts_apid left join shopping_order so der_oid = so.oid where 1=1 group by oha.autoparts_apid,a.second_class_scid,a.price |
select count(category_name) from category oltc |
select order_date 日期,count(oid) 订单数 from shopping_order where order_status = 1 group by day(order_date),oid; |
select order_date 日期,sum(total_price) 每次订单总价 from shopping_order where order_status = 1 group by day(order_date),total_price; |
select order_date 日期,avg(total_price) 每次订单总价 from shopping_order where order_status = 1 group by day(order_date),total_price; |
select max(hot_product) from autoparts |
select min(price) from autoparts |
select distinct(client.c_name) from client inner join shopping_order on shopping_order.client_cid = client.c_id |
select autoparts.ap_name from autoparts inner join shopping_cart on autoparts.ap_id = shopping_cart.autoparts_apid where client_cid = 1 |
本文发布于:2024-09-22 20:29:32,感谢您对本站的认可!
本文链接:https://www.17tex.com/tex/2/306783.html
版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。
留言与评论(共有 0 条评论) |