13.3k views
4 votes
you have two tables one have 3000 records and the other one have 2000 records - How much rows you get if you compare them?

User YuSolution
by
8.2k points

1 Answer

1 vote

Final answer:

The number of rows resulting from comparing two tables with 3000 and 2000 records depends on the type of database operation—such as a join or union. Specific probabilities cannot be calculated from the provided row and column totals without additional context. No switching between tables was needed to address these parts of the question.

Step-by-step explanation:

To address the question of how many rows you will get when comparing two tables with 3000 and 2000 records, we must consider what operation is being performed. If we are talking about joining tables in a database context, the result depends on the type of join. For instance, a FULL OUTER JOIN might result in anywhere from 3000 to 5000 rows if no matching records are found, or fewer if some records match. However, if you meant the union of the records from both tables, assuming there are no duplicates, you would get 5000 records.

To answer the provided probabilities question using the numbers you have given (total of 755 people, row totals of 305 and 450 and column totals of 70 and 685), you would use the joint probability formulas based on the context provided. Unfortunately, as there is not enough context in the question to determine the probability of a specific event, I cannot calculate a specific probability.

I have not switched between tables to answer your question as the information from your second table was insufficient to calculate probabilities without additional context.

User Mamal
by
8.1k points

No related questions found