Question: please answer the question Which query in this relational database (represented by relational diagram) will provide you with the list of 3 customers from Germany


please answer the question
Which query in this relational database (represented by relational diagram) will provide you with the list of 3 customers from Germany who bought most iPhones 11 phones? Select one: a. SELECT TOP(3) c.CompanyName, SUM(od.Quantity) FROM Products p INNER JOIN [Order Details] od ON p.ProductID = od.ProductID INNER JOIN Orders O ON od.OrderID =0. OrderiD INNER JOIN Customers c ON o.CustomerID = c.CustomeriD WHERE c.Country = 'Germany' AND p.ProductName = 'iPhone 11 ' GROUP BY c.CustomerID, c.CompanyName ORDER BY SUM(od.Quantity) DESC b. SELECT TOP(3) c.CustomeriD, c.CompanyName, Count(p.ProductID) FROM Products p RIGHT JOIN [Order Details] od ON p.ProductID = od.ProductID RIGHT JOIN Orders 0 ON od.Order ID=0. OrderID RIGHT JOIN Customers C ON o.Customer ID=c.CustomerlD WHERE p.ProductName = 'iPhone 11 ' AND c. Country = 'Germany' GROUP BY c.CustomerID, c.CompanyName, p.ProductID ORDER BY Count(p.ProductID) DESC c. SELECT TOP(3) c.CompanyName, p.ProductID, Sum(od.Quantity) FROM Products p LEFT JOIN [Order Details] od ON p.ProductID = od.ProductID LEFT JOIN Orders o ON od.OrderID =0. OrderID LEFT JOIN Customers c ON O.CustomerID = c.CustomerlD WHERE c.Country = 'Germany' AND p.ProductName = 'iPhone 11 ' GROUP BY p.ProductID, p.ProductName ORDER BY Sum(od.Quantity) DESC d. SELECT TOP(3) c.CustomerlD, c.CompanyName, Count(od.Quantity) FROM Products p LEFT JOIN [Order Details] od ON p.ProductID = od.ProductID LEFT JOIN Orders o ON od.OrderID =0. OrderID LEFT JOIN Customers C ON O.CustomerID = c.CustomerlD WHERE c.Country = 'Germany' AND p.ProductName = 'iPhone 11 ' GROUP BY c.CustomerID, c.CompanyName ORDER BY Count(od.Quantity) DESC e. SELECT TOP(3) c.CompanyName, Sum(p.ProductID) FROM Products p INNER JOIN Orders O ON p.Product ID =0. OrderID INNER JOIN Customers C ON o.CustomerID = c. CustomeriD WHERE c.Country = 'Germany' GROUP BY c.CompanyName AND 'iPhone 11' ORDER BY Sum(D. ProductID) DESC
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
