COURSES

SESSIONS

According

to the previous table, which table will be

the result of the query?

Select CTitle from Courses Where CID in

(Select S_CID from Sessions Where Scancel = 'C');

According

to the previous tables, which table will be

the result of the query?

Select

* from T1 right outer join T2 on ( Y = W );

Consider the following query

SELECT e.first_name, d.department_name 

FROM   employees e JOIN departments d

USING (department_id)

WHERE e.department_id = 100

Consider the following query

SELECT department_id, job_id, COUNT(last_name)

FROM   employees

In

the following table you can find the values of the SESSION table.

SESSIONS

According

to the previous table, which table will be

the result of the query?

SELECT S_CID, MAX(SDATE)

FROM SESSIONS

GROUP BY S_CID

HAVING COUNT(S_CID) >

2