![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
听说西佳佳难得很
要学的有好多……
是自己的功课,在这里没有必要欺骗自己,要好好弄懂在记录的知识点。感受到孤单的时候也要向前,努力成为最完善,最有力,最强大的自己。
展开
-
stratascratch刷题2 nubmer of bathrooms andbedrooms && Customer Details
1 解答 输入每个城市不同类别的房间类型中浴室和房间平均数 ---->不同城市 不同类别group by city, property_type 2 解答 因为“whether customer made an order" 所以 这边用来c left join a on…原创 2021-12-03 23:35:08 · 106 阅读 · 0 评论 -
stratascratch刷题1 salaries difference && Finding Updated Records
1 解题: select( (select max(salary)from db_employee join db_dept on db_employee.department_id = db_dept.id where department = 'marketing') - (select max(salary) from db_employee join db_dept on db_employee.department_id = db_dept.id where department = 'engi原创 2021-11-30 00:28:50 · 716 阅读 · 0 评论