Data selection in two tables

Tags:
tables
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
Questions:
  1. In a month how many times does a person place orders?
  2. Find the monthly expenses of senior citizen who are widowed?
  3. Find the month of highest purchase for all single persons?
  4. People from which locations have the max no of orders placed in a month and what is total expense?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Michael Tidmarsh
    Welcome to ITKE, Ashawalisingh! What program/platform are you using for your tables?
    65,700 pointsBadges:
    report
  • Subhendu Sen
    What is the database are you using now! What environment is there, is it an individual/ an office with shared/ remotely access. Please come back with more details.
    140,850 pointsBadges:
    report
  • clark445kent
    Hi, could you please be more specific about your query?
    8,235 pointsBadges:
    report
  • TheRealRaven
    Since this looks like a definite homework assignment, please show the work you've done so far and describe the problem you're having. We can probably guide you farther.
    And maybe especially even if it's an actual work problem, you should show what you have so far. You can't expect to post an assignment and have it done for you. Give us a particular problem to solve so we know what focus in needed.
    36,095 pointsBadges:
    report
  • ToddN2000
    Does this have to be done in one SQL statement? It sound like homework, but if you can post your code, we can show you how to correct it.
    134,855 pointsBadges:
    report
  • carlosdl
    Yeah, definitely homework.
    85,135 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: