Que: LINQ Query to list all purchases of $1000 or greater made by customers who live in Washington.

a. FROM p IN db.PurchasesWHERE p.Customer.Address.State == “WA” || p.Customer == NULLWHERE p.PurchaseItems.Sum (pi => pi.SaleAmount) = 1000SELECT p
b. FROM p IN db.PurchasesWHERE p.Customer.Address.State == “WA” || p.Customer == NULLWHERE p.PurchaseItems.Sum (pi => pi.SaleAmount) < 1000SELECT p
c. FROM p IN db.PurchasesWHERE p.Customer.Address.State == “WA” || p.Customer == NULLWHERE p.PurchaseItems.Sum (pi => pi.SaleAmount) > 1000SELECT p
d. None of the mentioned
Answer: FROM p IN db.PurchasesWHERE p.Customer.Address.State == “WA” || p.Customer == NULLWHERE p.PurchaseItems.Sum (pi => pi.SaleAmount) > 1000SELECT p

Leave a Comment