db2.3.1

1> Execute the two queries below. Why do these nearly identical statements produce two different
results? Name the difference and explain why.

SELECT code, description
FROM d_themes
WHERE code >200 AND description IN('Tropical', 'Football', 'Carnival');
SELECT code, description
FROM d_themes
WHERE code >200 OR description IN('Tropical', 'Football', 'Carnival');

2> Display the last names of all Global Fast Foods employees who have “e” and “i” in their last names.

3> “I need to know who the Global Fast Foods employees are that make more than $6.50/hour and
their position is not order taker.”

4> Using the employees table, write a query to display all employees whose last names start with “D”
and have “a” and “e” anywhere in their last name.

5> In which venues did DJs on Demand have events that were not in private homes?

6> Which list of operators is in the correct order from highest precedence to lowest precedence?

  • a. AND, NOT, OR

  • b. NOT, OR, AND

  • c. NOT, AND, OR

For questions 7 and 8, write SQL statements that will produce the desired output.

7> Who am I?
I was hired by Oracle after May 1998 but before June of 1999. My salary is less than $8000 a year
and I have an “en” in my last name.

8> What's my email address?
Because I have been working for Oracle since the beginning of 1996, I make more than $9000 per
month. Because I make so much money, I don't get a commission.

results for ""

    No results matching ""