俊俏后生a

分类

/ 注册

全部文章（共17篇）

题解 | 查找山东大学或者性别为男生的信息

SELECT device_id,gender,age,gpa FROM user_profile WHERE university='山东大学' UNION ALL SELECT device_id,gender,age,gpa FROM user_profile WHERE gender='m...

2025-08-25

0 46

题解 | 计算男生人数以及平均GPA

SELECT COUNT(*) AS male_num,AVG(gpa) AS avg_gpa FROM user_profile WHERE gender='male'

2025-08-23

0 25

题解 | 查看学校名称中含北京的用户

SELECT device_id,age,university FROM user_profile WHERE university LIKE '%北京%';

2025-08-23

0 43

题解 | 查看学校名称中含北京的用户

SELECT device_id,age,university FROM user_profile WHERE university LIKE '%北京%';

2025-08-23

0 27

题解 | 计算每日累计利润

SELECT profit_id,profit_date,profit, SUM(profit)OVER(ORDER BY profit_date) AS cumulative_profit FROM daily_profits ORDER BY profit_date;

2025-08-23

0 48

题解 | 操作符混合运用

SELECT device_id,gender,age,university,gpa FROM user_profile WHERE gpa>3.5 AND university='山东大学' OR gpa>3.8 AND university='复旦大学' ORDER BY devic...

2025-08-22

0 44

题解 | 求小球落地5次后所经历的路程和第5次反弹的高度

#include <cmath> #include <iostream> using namespace std; int main() { int high; cin>>high; double s=0.0; double h=...

2025-04-04

0 52

题解 | 倒置字符串

#include <algorithm> #include <iostream> #include <string> #include <vector> using namespace std; int main() { string str...

2025-04-04

0 66

题解 | 字符串中找出连续最长的数字串

#include <iostream> using namespace std; int main() { string s; cin>>s; string ret; string tmp; for(int i=0;i<s.si...

2025-04-04

0 60

题解 | 字符串变形

class Solution { public: /** * 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 * * * @param s string字符串 * @param n int整型 * @...

2025-03-22

0 62