Select code description from dthemes where code 200

This preview shows page 7 - 11 out of 13 pages.

We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
A Guide to SQL
The document you are viewing contains questions related to this textbook.
Chapter 3 / Exercise 11
A Guide to SQL
Last/Pratt
Expert Verified
SELECT code, descriptionFROM d_themesWHERE code >200 OR description IN('Tropical', 'Football', 'Carnival');8. 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.
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
A Guide to SQL
The document you are viewing contains questions related to this textbook.
Chapter 3 / Exercise 11
A Guide to SQL
Last/Pratt
Expert Verified
9. Write the SQL statement for the following:Who am I?
10. In the example below, assign the employee_id column the alias of “Number.” Complete the SQL statement to order the result set by the column alias.SELECT employee_id, first_name, last_nameFROM employees;
11. Write a SQL statement using the employees table and the ORDER BY clause that could retrieve the information in the following table. Return only those employees with employee_id<125.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture