牛牛菌不是男娘

分类

/ 注册

全部文章（共59篇）

题解 | 推荐内容准确的用户平均评分

with right_hobby_l as (select max(score) score from recommend_tb r left join user_action_tb u on r.rec_user = u.user_id where rec_info_l = hobby_l g...

2025-09-04

0 8

题解 | 统计所有课程参加培训人次

select sum( if(course is null, 0, length(course) - length(replace(course, ',', '')) + 1) ) staff_nums from cultivate_tb

2025-09-04

0 9

题解 | 分析客户逾期情况

with t1 as ( select ct.pay_ability pay_ability ,count(*) count ,sum(if(lt.overdue_days is not null, 1, 0)) num from loan_tb lt inner join customer_tb...

2025-09-04

0 7

题解 | 相同的Set

const _isSameSet = (s1, s2) => { // 补全代码 return s1.size === s2.size && new Set([...s1, ...s2]).size === s1.size }

2025-09-01

0 9

题解 | 验证是否是身份证

const _isCard = number => { return /[\d]{17}[\dX]/.test(number) }

2025-09-01

0 11

题解 | 判断质数

Number.prototype._isPrime = function (){ if (this < 2 || Math.floor(this) !== this.valueOf()) return false for (let i = 2; i < this; i++) { ...

2025-09-01

0 8

题解 | 数组扁平化

const _flatten = arr => { // 补全代码 function toFlat(arr){ let i = 0; while(true){ if(Array.isArray(arr[i])){ const subArr = arr[i] toFla...

2025-09-01

0 12

题解 | 类继承

class Human { constructor(name) { this.name = name this.kingdom = 'animal' this.color = ['yellow', 'white', 'brown', 'black'] } // 补全代码 get...

2025-09-01

0 12

题解 | 列表动态渲染

var people = [ { name: '牛油1号', id: 1, age: 20 }, { name: '牛油2号', id: 2, age: 21 }, { name: '牛油3号', id: 3, age: 19 }, ] var ul = document.querySe...

2025-09-01

0 11

题解 | 计数器

const closure = () => { // 补全代码 let num = 0 return ()=>{ num++ return num } }

2025-09-01

0 11