2021XX电商面经

1.python方法和函数的区别：

方法：实例化之后的是方法

函数：实例化之前是函数

from types import FunctionType,MethodType
class FuncMethod:
    def my_func(self):
        print("This is myfunc ")

    def my_method(self):
        print("This is mymethod")

if __name__ == '__main__':
    print(isinstance(FuncMethod.my_func,FunctionType))# True
    print(isinstance(FuncMethod.my_func,MethodType))# False
    f_m_obj = FuncMethod()
    print(isinstance(f_m_obj.my_func,FunctionType))# False
    print(isinstance(f_m_obj.my_func,MethodType))# True

2.字典推导式:

字典A-字典B=x

字典B-字典A=y

如：dict_a = {"a":1,"b":2,"c":3}

        dict_b = {"a":1,"d":4}

        dict_a-dict_b={"b":2,"c":3}

解答：

方式1，字典推导式

{x:dit_a[x] for x in dit_a.keys() if x not in dit_b.keys()}

方式2，循环

new_dict = dict()
for dk in dict_a.keys():
    if dk not in dict_b.keys():
        new_dict[dk]=dict_a[dk]
print(new_dict)

3.mysql题

学生表有五个字段：student(id,name,subject,score,remark)

用SQL实现分数分级并统计人数 score <=60  差，60<score <=80 良，score >80  优

实现的结果，如：差 20

                            良  30

                            优  50

思路：先把分数分级，在根据分级统计。
sql1：

SELECT CASE 
WHEN score <= 60 THEN '差'
WHEN score > 60 AND score <= 80 THEN '良'
WHEN score > 80 THEN '优' 
END AS '等级',count( * ) as '人数'
FROM student 
GROUP BY '等级';

sql2:

select t.score_lev '等级',count(*) '人数' from (SELECT CASE 
WHEN score <= 60 THEN '差'
WHEN score > 60 AND score <= 80 THEN '良'
WHEN score > 80 THEN '优' 
END AS score_lev
FROM student) t
GROUP BY t.score_lev;