Write a query to display the employee_id and department_id of the employees who works less than 50 percent_time. Display the records sorted in ascending order based on employee_id.

Assuming you are using SQL, here is a step-by-step guide on how to write the query:

1. Identify the table: The first step in writing a SQL query is to identify the table you are working with. In this case, it seems like you are working with an "employees" table.

2. Identify the columns: Next, identify the columns you need to work with. In this case, you need the "employee_id", "department_id", and "percent_time" columns.

3. Write the SELECT statement: Start your query with the SELECT statement, which is used to select data from a database. In this case, you want to select the "employee_id" and "department_id" columns.

4. Write the FROM statement: After the SELECT statement, write the FROM statement to specify the table you are selecting data from. In this case, the table is "employees".

5. Write the WHERE statement: The WHERE statement is used to filter records. In this case, you want to filter the records where "percent_time" is less than 50.

6. Write the ORDER BY statement: The ORDER BY statement is used to sort the result-set in ascending or descending order. In this case, you want to sort the results in ascending order based on "employee_id".

Here is the final query:

SELECT employee_id, department_id
FROM employees
WHERE percent_time < 50
ORDER BY employee_id ASC;

This query will display the "employee_id" and "department_id" of the employees who work less than 50 percent time, sorted in ascending order based on "employee_id".