Question $49$

Given the following database schema:

Products $($ProductID$,$ ProductName, CategoryID$)$

Categories $($CategoryID$,$ CategoryName$)$

Sales $($SaleID$,$ ProductID, SaleDate, Quantity, SaleAmount$)$

Customers $($CustomerID$,$ CustomerName$)$

Orders $($OrderID$,$ CustomerID, OrderDate$)$

which relational algebra expression returns the number

of orders placed by each customer in the year $2023?$

a$.$ none of these

b$.$ CustomerName,OrderCount COUNT$($OrderID$)($oYEAR$($OrderDate$)=2023($OrdersSales$*$Products$))$

c$.$ CustomerName,OrderCount$-$COUNT$($OrderID$)($oYEAR$($OrderDate$)=2023($OrdersProducts$*$Categories$))$

d$.$ CustomerName,OrderCount$-$COUNT$($OrderID$)($oYEAR$($OrderDate$)=2023($OrdersSales$))$

e$.$ CustomerName,OrderCount$-$COUNT$($OrderID$)($oYEAR$($OrderDate$)=2023($Orders$*$Customers$))$