问题
选择题
Thanks for _ me around the school last week. [ ]
A. show
B. showing
C. shows
D. to show
答案
答案：B
搜题请搜索小程序“爱下问搜题”
Thanks for _ me around the school last week. [ ]
A. show
B. showing
C. shows
D. to show
答案：B
以下是课程(CLASS)表和教师(INSTRUCTOR)表中的数据：
| CLASS | |||
| CLASS_ID | CLASS_NAME | HOURS_CREDIT | INSTRUCTOR_ID |
| 1 | Introduction to Accounting | 3 | 4 |
| 2 | Computer Basics | 3 | 1 |
| 3 | Tax Accounting Principles | 3 | 4 |
| 4 | American History | 3 | 2 |
| 5 | Basic Engineering | 3 | |
| INSTRUCTOR | ||
| INSTRUCTOR_ID | LAST_NAME | FIRST_NAME |
| 1 | Chao | Ling |
| 2 | Vanderbilt | Herbert |
| 3 | Wigley | Martha |
| 4 | Page | Albert |
A．SELECT i.last_name, i.first_name, c.class_name
FROM instructor i, class c;
B．SELECT i.last name, i.first_name,c.class_name
FROM class c LEFT OUTER JOIN instructor I
ON (i.instructor_id=c.instructor_id)
ORDER BY i.instructor_id;
C．SELECT i.last_name, i.first_name, c.class_name
FROM instructor i, class c
WHERE i.instructor_id=c.instructor_id (+)
ORDER BY i.instructor_id;
D．SELECT i.last_name, i.first_name, c.class_name
FROM instructor i LEFT OUTER JOIN class c
ON (i.instructor id=c.instructor_id)
ORDER BY i.instructor_id;
E．SELECT i.last_name, i.first_name, c.class_name
FROM instructor i, class c
WHERE i.instructor_id (+)=c.instructor_id
ORDER BY i.instructor_id;
F．SELECT i.last_name, i.first_name, c.class_name
FROM instructor i NATURAL JOIN class c
ON (i.instructor_id=c.instructor_id);