How to sort data with multiple conditions in sqlite3 in python?

Question

Python

There is a task with sqlite3 But I don't know how it can be implemented.
You need to sort the data by "Employee Name" and "date of employment"
If an employee has been working with the company for less than 1 year, then the bonus is 10%, and if the employee has been working for more than 1 year, then the bonus is 15%.
The user runs the script and the bot asks him to enter the name of the employee, after entering the name, the bot displays the bonus percentage.
PC In the database, all the data already exists, you need to implement this script.
I will be glad who will help me. Thank you.