landf31

分类

题解(71)

/ 注册

TA的专栏 1篇文章 0人订阅

1篇文章 592人学习

全部文章（共56篇）

题解 | #点击消除#

和匹配括号类似，先将字符入栈，若字符与栈中字符匹配，则出栈，否则入栈最后打印栈中剩余元素 import java.util.*; public class Main{ public static void main(String args[]){ Scanner sc=ne...

Java

2022-04-09

0 356

题解 | #查找输入整数二进制中1的个数#

import java.util.*; public class Main{ public static void main(String args[]){ Scanner sc=new Scanner(System.in); while(sc.hasNex...

Java

2022-04-07

0 317

题解 | #查找输入整数二进制中1的个数#

Integer类中的toBinaryString转化为二进制，将字符串0去掉，统计剩余字符长度 import java.util.*; public class Main{ public static void main(String args[]){ Scanner sc...

Java

2022-04-07

0 271

题解 | #查找组成一个偶数最接近的两个素数#

import java.util.*; public class Main { private static boolean isPrime(int num) {//判断是否为素数 for (int i = 2; i <= num/i; i++) { ...

Java

2022-04-07

0 341

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

select cust_email from Orders inner join OrderItems using(order_num) inner join Customers using(cust_id) where prod_id='BR01'; select cust_email fro...

Mysql

2022-04-06

0 327

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

select cust_id,order_date from Orders where order_num in (select order_num from OrderItems where prod_id='BR01') order by order_date; select cust_i...

Mysql

2022-04-06

0 285

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

order_num 两个表都有，需要指明使用的是哪个表 SELECT cust_name, Orders.order_num, SUM(quantity * item_price) AS OrderTotal FROM Customers INNER JOIN Orders on Customer...

Mysql

2022-04-06

0 351

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

SELECT cust_name, order_num, SUM(quantity * item_price) AS OrderTotal FROM Customers INNER JOIN Orders USING(cust_id) INNER JOIN OrderItems USING(ord...

Mysql

2022-04-06

0 288

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

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

Mysql

2022-04-06

0 343

题解 | #返回购买价格为 10 美元或以上产品的顾客列表#

select prod_name, sum(quantity) as quant_sold from Products , OrderItems where Products.prod_id = OrderItems.prod_id group by prod_name

Mysql

2022-04-05

0 248