Aviv has a grocery store. Aviv logs his data in his data center in the following manner:
• Customers (id, name, address, age, favorite soccer team)
• Products (id, name, price)
• Sales (date, customer_id, product_id, units_sold, paid_amount)
Query the tables and answer the following questions:
1. How many products with the name ‘Tomato’ were sold during Jan 1st, 2018?
(query should return a single row)
2. How much money was paid (paid_amount) in total for each product during Jan 2018. (query should return 2 columns – Product name and the total paid_amount)
3. Of which product did ‘A.S. Roma’ fans bought the most units?
ראיון לתפקיד 
