What does this query mean (express the meaning in one short English sentence)? Write an equivalent SQL query without using the IN operator and the set construct.

Consider the following query:

```
SELECT S.Name
FROM Student S, Transcript T
WHERE S.Id = T.StudId
AND T.CrsCode IN (’CS305’,’CS315’)
```


The equivalent SQL query to query (7.33) is:
```
SELECT S.Name
FROM Student S, Transcript T
WHERE S.Id = T.StudId
AND (T.CrsCode = ’CS305’ OR T.CrsCode = ’CS315’)
```

The meaning of the query is: the names of all students who took CS305 or CS315.

Computer Science & Information Technology

You might also like to view...

Write SQL*Plus commands to do the following:

a) Connect to the database ‘OracleDB’ with the user name ‘SalesTracking’ and password ‘sales’; b) Make sure that the Autocommit is off; c) Display the name of the current user; d) List the names of all tables in this schema; e) Display the structure of the table Branch; f) List the names of all sequences in this schema.

Computer Science & Information Technology

In a chart, a ________ smoothes the fluctuations in data, thus showing a pattern or trend more clearly

Fill in the blank(s) with correct word

Computer Science & Information Technology

If formatting marks are displayed, a manual page break appears immediately after the last line of text on the page. It is indicated by a ____ with the words Page Break in the middle of the line.

A. solid line B. dotted line C. dashed line D. double line

Computer Science & Information Technology

Windows 10 can display only one other clock(s) besides the default clock.??

Answer the following statement true (T) or false (F)

Computer Science & Information Technology