Que: Query alternative to the following LINQ code in SQL is ____________
FROM p IN db.Purchases
WHERE p.Customer.Address.State == "WA" || p.Customer == NULL
WHERE p.PurchaseItems.Sum (pi => pi.SaleAmount) > 1000
SELECT p
a. SELECT p.*FROM Purchase pLEFT OUTER JOINCustomer c INNER JOIN Address a ON c.AddressID = a.IDON p.CustomerID = c.IDWHERE(a.State = ‘WA’ || p.CustomerID IS NULL)AND p.ID IN(SELECT PurchaseID FROM PurchaseItemGROUP BY PurchaseID WHERE SUM (SaleAmount) > 1000)
b. SELECT p.*FROM Purchase pLEFT OUTER JOINCustomer c INNER JOIN Address a ON c.AddressID = a.IDON p.CustomerID = c.IDWHERE(a.State = ‘WA’ || p.CustomerID IS NULL)AND p.ID IN(SELECT PurchaseID FROM PurchaseItemGROUP BY PurchaseID HAVING SUM (SaleAmount) > 1000)
c. SELECT p.*FROM Purchase pLEFT OUTER JOINCustomer c INNER JOIN Address a ON c.AddressID = a.IDON p.CustomerID = c.IDWHERE(a.State = ‘WA’ || p.CustomerID IS NULL)AND p.ID IN(SELECT PurchaseID FROM PurchaseItemGROUP BY PurchaseID HAVING SUM (SaleAmount) < 1000)
d. None of the mentioned
Answer: SELECT p.*FROM Purchase pLEFT OUTER JOINCustomer c INNER JOIN Address a ON c.AddressID = a.IDON p.CustomerID = c.IDWHERE(a.State = ‘WA’ || p.CustomerID IS NULL)AND p.ID IN(SELECT PurchaseID FROM PurchaseItemGROUP BY PurchaseID HAVING SUM (SaleAmount) > 1000)