Dinochang

分类

题解(6)

/ 注册

全部文章（共6篇）

题解 | #获取有奖金的员工相关信息。#

select eb.emp_no, e.first_name, e.last_name, eb.btype, s.salary, round(s.salary * (case eb.btype when 1 then 0.1...

2022-04-29

7 454

题解 | #查找在职员工自入职以来的薪水涨幅情况#

# select emp_no, (max(salary) - min(salary)) growth # from salaries # where emp_no in (select if(to_date = '9999-01-01', emp_no, null) working from s...

2022-04-27

1 406

题解 | #二叉树的深度#

# -*- coding:utf-8 -*- # class TreeNode: # def __init__(self, x): # self.val = x # self.left = None # self.right = None cl...

2022-04-09

0 326

题解 | #调整数组顺序使奇数位于偶数前面(一)#

class Solution: def reOrderArray(self , array ): # write code here # 类似于冒泡排序 length = len(array) for i in range(le...

2022-04-06

1 298

题解 | #将两个 SELECT 语句结合起来（一）#

(select * from OrderItems where quantity = 100) union (select * from OrderItems where prod_id like 'BNBG%')

2022-04-04

2 370

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

select vend_id, count(prod_id) prod_id from Vendors left join Products using (vend_id) group by vend_id order by vend_id asc

2022-04-04

2 591