Comparison+Operators

Only work on this assignment if you finished the SQLZoo Assignment!
//Answer the following in Word and submit to Engrade.//

1. Display the first name, last name, and salary of all Global Fast Foods staff whose salary is between $5.00 and $10.00 per hour.

2. Display the location type and comments for all DJs on Demand venues that are Private Home.

3. Using only the less than, equal, or greater than operators, rewrite the following query:

SELECT first_name, last_name FROM f_staffs WHERE salary BETWEEN 20.00 and 60.00

4. Create a list of all the DJs on Demand CD titles that have “a” as the second letter in the title.

5. Who are the partners of DJs on Demand who do not get an authorized expense amount?

6. Select all the Oracle database employees whose last names end with “s”.

7. Which statement(s) are valid?
 * a. WHERE quantity <> NULL;
 * b. WHERE quantity = NULL;
 * c. WHERE quantity IS NULL;
 * d. WHERE quantity != NULL;

8. Write a SQL statement that lists the songs in the DJs on Demand inventory that are type code 77, 12 or 1.

9. The following query was supposed to return the CD title “Carpe Diem" but no rows were returned. Correct the mistake in the statement and show the output.

SELECT produce, title FROM d_cds WHERE title = 'carpe diem'

10. Write a SQL statement that will list the titles and years of all the DJs on Demand's CDs that were not produced in 2000.

11. Write a SQL statement that lists the Global Fast Foods employees who were born before 1980.