1.Logistic Regression Model Coding: Using Train Test Dataset
2.SQL query for finding 213th highest score in student table.
3.Assessing Linear Regression Assumptions
4.Linear Regression Model for Single Label Prediction
5.kNN-based Train & Test Prediction
6.Companies with Average Salaries above a Certain Threshold
7.Poisson Distribution Estimation for Various Scenarios
8.Programming Question: Server Request Handling with Thread Pool.
9.Account Transactions Query
10.Finest Food Outlet Retrieval
11.SQL Grouping and Filtering
12.Algorithm to Minimize Cost Function by Inserting a Number
13.Algorithm for Packet Transmission Times
14.SQL Query to Find Overloaded Game Inventories
15.SQL Query to Count Active Domains and Identify Nearest Expiration
16.SQL Query for Accounting Number Format Transactions
17.SQL Query for Top Three Math Scores
18.Convert Integers to Roman Numerals
19.MMORPG Inventory Query Problem
20.Good Array Query Problem
21.SQL Query for Active Users and Domains
22.Find protocols where the sum of incoming traffic is greater than the sum of outgoing traffic
23.Retrieve the top three math scores from students
24.Count the number of purchase records for May 2022
25.Select hardware with higher downstream rate than upstream rate and minimal downtime
26.Identify students with a total score over 500
27.Find CVM configurations and number of deployments for the year 2021
28.Calculate Total Inventory Weight for MMORPG Accounts
29.SQL Query for Banner Information by City
30.SQL Query for Protocol Traffic Analysis
31.SQL Query for Banners in Cities
32.Network Traffic Database Query
33.HTTP Request Log Analysis
34.Active Encryption Salt Length Audit
35.Find the k-th Factor of a Number
36.Calculate the Product of Elements in an Array After Modulo Operation
37.Database Security Audit Query
38.Simple SQL JOIN Query
39.Find the Number of Active Encryptions
40.Generate a Sales Report for June 2022
41.SQL Query Writing
42.SQL Query to Filter Sum Greater Than 10 After Join
43.SQL Query for Account-Item Relationship
44.MMORPG SQL Query
45.SQL Problem
46.Generate a Summary Table from Accounts and Transactions
47.SQL Query to Find Professors Teaching Courses Outside Their Department
48.Coding Task: File Reading and Data Testing Function
49.Experience Detailing
50.Simple SQL Query Execution
51.SQL Formatting Challenge
52.Maximize the Minimum Missing Integer After Reduction
1. Logistic Regression Model Coding: Using Train Test Dataset
Logistics Regression coding。 给定train test dataset, 要求code一个logistics regression model出来。
2. SQL query for finding 213th highest score in student table.
SQL：给定一个student成绩table (D;Name;Score)，要求输出第213高的成绩分数。
3. Assessing Linear Regression Assumptions
Linear Regression Assumption考察
4. Linear Regression Model for Single Label Prediction
model:给了training.csv,test.csv，要求提交submission.csv，训练数据有几个特征和一个label，要求用linear regression拟合label
5. kNN-based Train & Test Prediction
网页Jupyter Notebook IDE，提供train&test，要求用kNN predict
解锁更多真题，请点此 登录 篱笆帮
高频题（0）
