Thanks! We'll email you
when relevant content is
added and updated.
There are 2 tables:
Cust_table and order_table, column in table 1: cust_id, name, location , age, marital status(single, married, widowed)
Column in table 2:
Order id, Cust_id, order amount, month of purchase
- In a month how many times does a person place orders?
- Find the monthly expenses of senior citizen who are widowed?
- Find the month of highest purchase for all single persons?
- People from which locations have the max no of orders placed in a month and what is total expense?