![](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_type2解答因为“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_employeejoin db_dept ondb_employee.department_id = db_dept.idwhere department = 'marketing')-(select max(salary) from db_employeejoin db_dept ondb_employee.department_id = db_dept.idwhere department = 'engi原创 2021-11-30 00:28:50 · 715 阅读 · 0 评论