Which three are true about multiple INSERT statements?

Examine the description of the employees table:

Examine these requirements:
1- Display the last name, date of hire and the number of years of service for each employee.
2. If the employee has been employed 5 or more years but less than 10, display -5+ years of service".
3. If the employee has been employed 10 or more years but less than 15, display "10+ years of service".
4. If the employee has been employed 15 or more years, display "15-*- years of service".
5. If none of these conditions matches, display "<5 years of service".
6. Sort the results by the hire_date column.
Which statement satisfies all the requirements?

Examine the description of the PRODUCT_STATUS table:

The STATUS column contains the values 'IN STOCK' or 'OUT OF STOCK' for each row Which two queries will execute successfully?

Which two statements cause changes to the data dictionary?

Examine the data in the EMPLOYEES table:

Which statement will compute the total annual compensation for each employee?