OK - let's look at this step by step.
First, a very basic query to start us off:
Select LOCGUID
from table
this will return the list of LOCGUIDs (100,100,200,300,300,400)
we only want the items that have INA in the column Status so we can add a WHERE clause:
Select LOCGUID
from table
where Status = 'INA'
We now have a list that looks like: (100,100,300,400)
There are a couple of ways we can get rid of duplicates. For more complex expressions you can use GROUP BY clauses, but we can simply use the DISTINCT selector:
Select distinct LOCGUID
from table
where Status = 'INA'
Great. We have the unique LOCGUIDs where Status = 'INA' : (100,300,400)
Your list will look like this:
LOCGUID
----
100
300
400
Did you miss the '300' by mistake or is there another criteria that would eliminate it?