奥鹏作业答案 - 分忧网!奥鹏作业答案,奥鹏在线作业答案,奥鹏作业答案及毕业论文分忧

电大作业答案,国开在线作业答案,国开在线考核_分忧网

当前位置: 主页 > 形考线下 >

Given the tables:

时间:2021-07-08 13:02来源:未知 作者:admin 点击:
(单选题)23: Given the tables: COUNTRY STAFF id name person cities id name 1 Argentina 1 10 1 Aaron 2 Canada 2 20 2 Adams 3 Cuba 2 10 3 Jones 4 Germany 1 0 5 France 3 5 6 Italy 1 5 the report: id name number_of_countries ---------
(单选题)23: Given the tables: COUNTRY STAFF id name person cities id name 1 Argentina 1 10 1 Aaron 2 Canada 2 20 2 Adams 3 Cuba 2 10 3 Jones 4 Germany 1 0 5 France 3 5 6 Italy 1 5 the report: id name number_of_countries ---------- ---------- ------------------- 1 Aaron 3 and the SQL statement: SELECT B.id,B.name,COUNT(DISTINCT A.name) AS number_of_countries FROM country A, staff B WHERE B.id=A.person GROUP BY B.id,B.name HAVING COUNT(DISTINCT A.name)>:count_var Which of the following values does :count_var require to print out the above report?
A: 1
B: 2
C: 3
D: 4
正确答案:♦B♦
(责任编辑:admin)有不懂可以加客服微信:vq800020900 咨询
------分隔线----------------------------
猜您喜欢
栏目导航
推荐内容
热点内容

要做作业扫码我

微信扫码客服

提示信息×