2025年银行《金融数据分析岗》SQL数据可视化模拟题库.docxVIP

2025年银行《金融数据分析岗》SQL数据可视化模拟题库

姓名：__________考号：__________

题号

一

二

三

四

五

总分

评分

一、单选题(共10题)

1.以下哪个SQL语句可以查询2024年1月1日到2024年12月31日所有贷款余额超过10000的客户ID和贷款余额？()

A.SELECTcustomer_id,loan_balanceFROMloansWHEREloan_balance10000ANDloan_dateBETWEEN2024-01-01AND2024-12-31;

B.SELECTcustomer_id,loan_balanceFROMloansWHEREloan_balance10000ANDloan_date=2024-01-01ANDloan_date=2024-12-31;

C.SELECTcustomer_id,loan_balanceFROMloansWHEREloan_balance10000ANDloan_date2024-01-01ANDloan_date2024-12-31;

D.SELECTcustomer_id,loan_balanceFROMloansWHEREloan_balance10000ANDloan_date=2024-01-01ANDloan_date=2024-12-31;

2.如何使用SQL语句计算所有贷款的平均余额？()

A.SELECTAVG(loan_balance)FROMloans;

B.SELECTloan_balanceFROMloansGROUPBYloan_balance;

C.SELECTloan_balanceFROMloansORDERBYloan_balance;

D.SELECTloan_balanceFROMloansWHEREloan_balance0;

3.以下哪个SQL语句可以更新客户ID为100的客户姓名为张三？()

A.UPDATEcustomersSETname=张三WHEREcustomer_id=100;

B.UPDATEcustomersSETname=张三WHEREcustomer_id=100;

C.UPDATEcustomersSETname=张三WHEREcustomer_id=100.0;

D.UPDATEcustomersSETname=张三WHEREcustomer_id=100.0;

4.如何使用SQL语句计算每个客户的贷款数量？()

A.SELECTcustomer_id,COUNT(*)FROMloansGROUPBYcustomer_id;

B.SELECTcustomer_id,loan_idFROMloansGROUPBYcustomer_id;

C.SELECTcustomer_id,loan_balanceFROMloansGROUPBYcustomer_id;

D.SELECTcustomer_id,loan_dateFROMloansGROUPBYcustomer_id;

5.以下哪个SQL语句可以查询所有贷款余额在5000到15000之间的客户ID和贷款余额？()

A.SELECTcustomer_id,loan_balanceFROMloansWHEREloan_balanceBETWEEN5000AND15000;

B.SELECTcustomer_id,loan_balanceFROMloansWHEREloan_balance=5000ANDloan_balance=15000;

C.SELECTcustomer_id,loan_balanceFROMloansWHEREloan_balance5000ANDloan_balance15000;

D.SELECTcustomer_id,loan_balanceFROMloansWHEREloan_balance=5000ORloan_balance=15000;

6.如何使用SQL语句计算所有贷款的平均利率？()

A.SELECTAVG(interest_rate)FROMloans;

B.SELECTint