Write a query that selects all orders (Order table) except those with zeros or NULLS in the amt field.

Q. Write a query that selects all orders (Order table) except those with zeros or NULLS in the amt field.

Answer =

Select * from Order
Where amt is not null and amt <> 0 ;