Mаtch the fоllоwing wоrds with their correct definitions:
Relаtiоnаl Algebrа (Part 3) — Prоducts Sоld Instructions The following schema shows a simplified data model for selling and buying on Amazon.com: Product(pid, pname, price, rid) Retailer(rid, rname, rating, city) Customer(cid, email, city) Order(cid, pid, date, shipping) You must answer the following query using relational algebra: "Get the total number of products sold on 01/01/2015 for each retailer, along with retailer IDs and name (rid and rname)." How to complete this question: Below are four relational algebra expressions—one is correct, while the others contain errors. Select the correct expression that accurately represents the query. Note: The symbol Γ (Gamma) represents aggregation (grouping) in relational algebra, similar to the GROUP BY clause in SQL. Relational Algebra Expressions: Option 1 Γrid, rname, COUNT(pid) (Order ⨝ Product ⨝ Retailer) Option 2 Γrid, rname, COUNT(pid) (σdate='01/01/2015' (Order) ⨝ Product ⨝ Retailer) Option 3 Γrid, rname, COUNT(pid) (σdate=′01/01/2015′(Order)) ⨝ Product ⨝ Retailer Option 4 Γrid, rname, COUNT(pid) (σdate=′01/01/2015′(Order)) Select the correct option: [ques1_part3_options]