面经很简单的

移动零

class Solution {public void moveZeroes(int[] nums) {int n = nums.length;int k = 0;for (int i = 0; i < n; i++) {if (nums[i] != 0) {nums[k++] = nums[i];}}for (int i = k; i < n; i++) {nums[k++] = 0;}}
}

在线SQL运行环境推荐：

• SQLFiddle: http://sqlfiddle.com/

• DB Fiddle: https://www.db-fiddle.com/

• SQL Online IDE: https://sqliteonline.com/

CREATE TABLE StudentScores (Name VARCHAR(50),Course VARCHAR(50),Score INT
);INSERT INTO StudentScores VALUES ('Zhang San', 'Chinese', 81);
INSERT INTO StudentScores VALUES ('Zhang San', 'Math', 75);
INSERT INTO StudentScores VALUES ('Li Si', 'Chinese', 76);
INSERT INTO StudentScores VALUES ('Li Si', 'Math', 90);
INSERT INTO StudentScores VALUES ('Wang Wu', 'Chinese', 81);
INSERT INTO StudentScores VALUES ('Wang Wu', 'Math', 100);
INSERT INTO StudentScores VALUES ('Wang Wu', 'English', 90);SELECT Name
FROM StudentScores
GROUP BY Name
HAVING MIN(Score) > 75;

SELECT Name: 选择学生姓名。

FROM StudentScores: 从 StudentScores 表中查询。

GROUP BY Name: 按姓名将记录分组、这样每个学生的所有课程成绩都在同一个组里。

HAVING MIN(Score) > 75: 对每个分组（即每个学生）应用条件，MIN(Score) 找出该学生所有课程中的最低分、只有当最低分也大于75、该学生的姓名才会被选中。