I am try to write a query and get the result show below but get stock.  Any
help would greatly appreciate.

drop table #temp
go
CREATE TABLE #temp
(
  Agent_nb   INT          NULL,
  LastName   VARCHAR(15)  NULL,
  FirstName  VARCHAR(15)  NULL,
  Auto_nb    INT          NULL,
  ClueOrder  INT          NULL
)
go
INSERT #temp VALUES (1977, 'Chan', 'Wendy', 25, 5)
INSERT #temp VALUES (2803, 'Leslie', 'Kenneth', 23, 3)
INSERT #temp VALUES (3080, 'Anderson', 'Melisa', 0, 0)
INSERT #temp VALUES (5411, 'Langford', 'Jonlyn', 0, 1)
INSERT #temp VALUES (6600, 'Jolly', 'Christopher', 1, 0)
go

SELECT *
  FROM #temp
go

-- Business Rules:  Exclude all records with Auto_nb = 0 and ClueOrder = 0.

Result want:
Agent_nb    LastName        FirstName       Auto_nb     ClueOrder  
----------- --------------- --------------- ----------- -----------
1977        Chan            Wendy           25          5
2803        Leslie          Kenneth         23          3
5411        Langford        Jonlyn          0           1
6600        Jolly           Christopher     1           0

     SELECT *
      FROM #temp
     go

-----------------------------------------------Reply-----------------------------------------------