Write a SELECT statement that pulls all of the rows from a single field called LAST_NAME in a table called STAFF.

 

2-Write a SELECT statement that pulls all of the rows from all of the fields in a table called PRODUCT.

 

3-**Write a SELECT statement that outputs all rows from the fields LAST_NAME and FIRST_NAME, as well as a derived column that concatenates FIRST_NAME and LAST_NAME (use the concat(field1, field2) function) from the table CUSTOMER. Alias the field as FULL_NAME. Sort by LAST_NAME, then by FIRST_NAME.

 

4-Write a SELECT statement that lists CITY names (field: CITY) from the STATION table that do not end with vowels. Your result cannot contain duplicates.

 

5-Write a SELECT statement that lists the NAME (field: NAME) of all students in the STUDENTS table who scored higher than 75 (field: SCORE). Sort by the last three characters of each NAME. If two or more students both have names ending in the same last three characters (i.e.: Bobby, Robby, etc.), then use a secondary sort on the ID field.

 

6- Write a SELECT statement that returns all rows with salary, last name, street address and ZIP code (SALARY, LAST_NAME, STREET, ZIP_CODE) from the EMPLOYEE and ADDRESS tables, sorted by SALARY from largest to smallest. STREET and ZIP_CODE are in the ADDRESS table, while the other fields are in the EMPLOYEE table. The common key is EMPLOYEE_ID.

 

7-**List unique first (first_name) and last names (last_name) of customers (CUSTOMER table) who rented a movie (RENTAL table) between '2011-06-01' and '2012-01-01' (rental_date). Sort by last_name. The common key is CUSTOMER_ID.

 

8-**List the title (title) of all films (FILM table) with category.name='Foreign'. You must use a WHERE clause that filters on the actual category name--not the ID. You will need to join three tables--FILM, FILM_CATEGORY, and CATEGORY. The common keys are FILM_ID and CATEGORY_ID.