Database Management Systems

We are given the query:

SELECT LastName FROM Table-1 WHERE State = "IN" ORDER BY FirstName

Let's filter the table rows where State is "IN":
- Squires, Edwin — IN
- Rothrock, Paul — IN
- Ramirez, Douglas — IN

Now, order these by the FirstName column:
1. Douglas (Ramirez)
2. Edwin (Squires)
3. Paul (Rothrock)

So, the first entry by alphabetical order of FirstName is Douglas, and the corresponding LastName is Ramirez.
Answer: Ramirez