注册一亩三分地论坛,查看更多干货!
您需要 登录 才可以下载或查看附件。没有帐号?注册账号 
x
给地里的大家分享一道Finra Big Data Analyst的pre-screen SQL 题目。也想顺便问一下大家对这道SQL题目的看法~
. .и
Table Name: CUSTOMERS
CUSTOMER_ID STATUS FNAME MNAME LNAME GENDER AGE
1 Active John Smith M 70
2 Active James Emitt Madison M 68
3 ActivDISTINCT CUSTOMERS. CUSTOMER_ID), count(*), count(DISTINCT CUSTOMERS.AGE)
FROM CUSTOMERS
GROUP BY CUSTOMERS.GENDER;
|