Write an SQL statement that returns the names (not the Ids) of all students who received an A in CS305 in the fall of 2000.

What will be an ideal response?


```
SELECT Name
FROM Student, Transcript
WHERE StudId = Id AND Grade = ’A’
AND CrsCode = ’CS305’ AND Semester = ’F2000’
```

Computer Science & Information Technology

You might also like to view...

Select a major function of E-Commerce.

a. using SSL to encrypt orders b. adding items to a shopping cart c. the buying and selling of goods d. none of the above

Computer Science & Information Technology

The tool that improves database performance and decreases the size of the database is called ________ and Repair

Fill in the blank(s) with correct word

Computer Science & Information Technology

In the accompanying figure, Item 3 indicates that red has been selected as a theme color on the ____.

A. Color Dialog box B. Color Palette C. Text Effects gallery D. Format Painter

Computer Science & Information Technology

When enabled, ________ requires a password and a verification code to sign into a device for the first time.

a. keychain b. keylogger c. password manager d. two-factor authentication

Computer Science & Information Technology