shenggong
shenggong
全部文章
题解
归档
标签
去牛客网
登录
/
注册
shenggong的博客
全部文章
/ 题解
(共35篇)
题解 | #牛牛的等差数列#
import java.io.BufferedReader; import java.io.IOException; import java.io.InputStreamReader; public class Main{ public static void main(String[] args)...
Java
2022-05-04
0
171
题解 | #整数的十位#
import java.util.Scanner; public class Main{ public static void main(String[] args){ Scanner sc = new Scanner(System.in); float f = sc.nextFloat(); Sy...
Java
2022-04-29
0
151
题解 | #判断学生成绩等级#
import java.util.Scanner; public class Main { public static void main(String[] args) { Scanner scanner = new Scanner(System.in); String grade =scanner...
Java
2022-04-04
1
202
题解 | #判断体重指数#
import java.util.Scanner; public class Main { public static void main(String[] args) { Scanner scanner = new Scanner(System.in); double height = scann...
Java
2022-04-04
0
278
题解 | #纠错4#
SELECT cust_name, cust_contact, cust_email FROM Customers WHERE cust_state = 'MI' UNION SELECT cust_name, cust_contact, cust_email FROM Customers WHER...
Mysql
2022-03-27
0
368
题解 | #将两个 SELECT 语句结合起来(一)#
SELECT prod_id,quantity FROM OrderItems WHERE quantity=100 UNION SELECT prod_id,quantity FROM OrderItems WHERE prod_id LIKE 'BNBG%' ORDER BY prod_id A...
Mysql
2022-03-27
0
182
题解 | #列出供应商及其可供产品的数量#
SELECT a.vend_id,COUNT(b.prod_id) FROM Vendors a LEFT JOIN Products b ON a.vend_id=b.vend_id GROUP BY a.vend_id ORDER BY a.vend_id ASC;
Mysql
2022-03-26
0
191
题解 | #返回产品名称和每一项产品的总订单数#
SELECT a.prod_name,COUNT(b.order_num) AS orders FROM Products a LEFT JOIN OrderItems b ON a.prod_id=b.prod_id GROUP BY a.prod_name ORDER BY a.prod_nam...
Mysql
2022-03-26
0
194
题解 | #确定最佳顾客的另一种方式(二)#
SELECT c.cust_name,SUM(a.item_price*a.quantity) AS total_price FROM OrderItems a INNER JOIN Orders b ON a.order_num = b.order_num INNER JOIN Customer...
Mysql
2022-03-25
0
231
题解 | #返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件(二)#
SELECT c.cust_email FROM OrderItems a INNER JOIN Orders b ON a.order_num = b.order_num INNER JOIN Customers c ON b.cust_id=c.cust_id WHERE a.prod_id =...
Mysql
2022-03-24
0
159
首页
上一页
1
2
3
4
下一页
末页