SQL - Asked by Amazon We're given two tables. Table A has one million records with fields ID and AGE. Table B has 100 records with two fields as well, ID and SALARY.
Let's say in Table B, the mean salary is 50K and the median salary is 100K.

SELECT A.ID,A.AGE,B.SALARY
FROM A
LEFT JOIN B
ON A.ID = B.ID
WHERE B.SALARY > 50000

Given the query above gets run, about how many records would be returned? a. 500K b. 33 c. 50 d. 330K e. 66 How would I know the exact number of the rows to be returned without working on the tables myself? My rough estimations suggest that the number would be between 50 and 66. I can guess that the exact number is tied up with the provided mean and median. But it doesnt tell me anything apart from the fact that Table B is right-skewed. I'd appreciate a guide here. Thank you.

How do I solve this SQL question?

Submit an answer