Filter Employees by Alphabetical Last Name Range

Problem Statement

Problem Description Write a SQL query to extract all employees whose last_name falls alphabetically between 'Hall' and 'Reed' (inclusive). Schema The employees table has the following schema: +--------------+---------------+ | Column Name | Type | +--------------+---------------+ | id | INTEGER | | first_name | VARCHAR(50) | | last_name | VARCHAR(50) | | num_years | INTEGER | | satisfaction | DECIMAL(25,5) | +--------------+---------------+ Required Output The result set must contain exactly two columns: first_name and last_name , strictly in that order. The rows must be sorted in ascending alphabetical order by last_name . If multiple employees have the exact same last name, sort them secondarily by first_name in ascending alphabetical order to ensure deterministic results. Constraints or Notes The alphabetical range is inclusive. An employee with the exact last name 'Hall' or 'Reed' should be included in the result set. Standard SQL string comparison rules apply. For example, 'Reeder