in sql

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. (derived from https://www.hackerrank.com/challenges/name-of-employees/problemLinks to an external site.)

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.