阿莉勒丝黛拉

题解

/ 注册

全部文章 / 题解（共162篇）

题解 | #列出供应商及其可供产品的数量#

SELECT v.vend_id vend_id, COUNT(p.prod_id) prod_id FROM Vendors v LEFT JOIN P...

Mysql

2022-03-09

18 2206

题解 | #返回产品名称和每一项产品的总订单数#

SELECT p.prod_name prod_name, COUNT(oi.order_num) orders FROM Products p LEFT JOIN...

Mysql

2022-03-09

23 621

题解 | #返回产品名称和与之相关的订单号#

SELECT p.prod_name prod_name, oi.order_num order_num FROM Products p LEFT JOIN&nbs...

Mysql

2022-03-09

3 611

题解 | #检索每个顾客的名称和所有的订单号（二）#

SELECT c.cust_name cust_name, o.order_num order_num FROM Customers c LEFT JOIN&nbs...

Mysql

2022-03-09

6 535

题解 | #检索每个顾客的名称和所有的订单号（一）#

SELECT c.cust_name cust_name, o.order_num order_num FROM Customers c INNER JOIN&nb...

Mysql

2022-03-09

1 672

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

SELECT c.cust_name cust_name, tb.total_price total_price FROM Customers c INNER JOIN Orders o ON ...

Mysql

2022-03-09

5 1184

题解 | #返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（二）#

SELECT c.cust_email cust_email FROM OrderItems oi INNER JOIN Orders&nbs...

Mysql

2022-03-09

3 804

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

SELECT o.cust_id cust_id, o.order_date order_date FROM OrderItems oi IN...

Mysql

2022-03-08

4 684

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

SELECT c.cust_name cust_name, o.order_num order_num, SUM(oi.qu...

Mysql

2022-03-08

14 1349

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

SELECT cust_name, order_num FROM Customers c INNER JOIN&n...

Mysql

2022-03-08

2 474