人生苦短，但求成长

题解

/ 注册

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

题解 | #检索并列出已订购产品的清单#

select order_num,prod_id,quantity from OrderItems where prod_id in ('BR01','BR02','BR03') and quantity ...

Mysql

2022-03-12

3 594

题解 | #检索供应商名称#

select vend_name from Vendors where vend_country = 'USA' and vend_state = 'CA'

Mysql

2022-03-12

1 402

题解 | #返回产品并且按照价格排序#

select prod_name,prod_price from Products where prod_price >= 3 and prod_price <= 6 order&nbs...

Mysql

2022-03-12

4 509

题解 | #按照数量和价格排序#

select quantity,item_price from OrderItems order by quantity desc,item_price desc

Mysql

2022-03-12

3 395

题解 | #仅检索顾客的ID#

select cust_id,cust_name from Customers #select cust_id from Customers

Mysql

2022-03-12

6 882

题解 | #21年8月份练题总数#

select count(distinct device_id) as did_cnt ,count(question_id) as ...

Mysql

2022-03-12

1 234

题解 | #统计复旦用户8月练题情况#

select t3.difficult_level, sum(if(t2.result = 'right',1,0))/count(1) as corr...

Mysql 数据库

2022-03-12

1 280

题解 | #统计复旦用户8月练题情况#

select t3.difficult_level, sum(if(t2.result = 'right',1,0))/count(1) as correct_rate from (select device_id...

Mysql 数据库

2022-03-12

0 237

题解 | #统计复旦用户8月练题情况#

select t1.device_id, university, count(t2.question_id) as question_cnt, sum( &nb...

Mysql 数据库

2022-03-12

1 245

题解 | #找出每个学校GPA最低的同学#

select t1.device_id, t1.university, t1.gpa from user_profile t1 join( &nb...

Mysql

2022-03-12

1 255