using sql

Using the SELECT statement perform the following on the table: HRDEPARTMENTS 1. Select all the records in the table with all of the fields from the table 2. Create a SELECT statement to select a Department ID Department_Name and Location_ID with an Alias 3. Create a select statement to select all the fields in HR.DEPARTMENT sorted by manager 4. Create a select statement to select all fields in DEPARTMENT with manager id greater than 200 5. Create a select statement to select all fields in DEPARTMENT displaying all departments for location 1700 6. Create a select statement to select all fields in DEPARTMENT with all department names ending in : ing For example Training, Marketing and Purchasing 7. Create a select statement to select all fields in DEPARTMENT with all departments with the range of 40 to 90 (including 40 and 90). 8. Using a "IN" list department id's 90,100 and 110