*Note: someone else answered the question but queried for theaverage. I need the median NOT the average.Thanks.
Hi, please help me create the following SQLquery:
Create Table A with 1 column and 10 rows. The rows are filledwith numbers : 1,2,3,4,5,6,7,8,9,10.
Create Table B with 1 column and 9 rows. The rows are filledwith numbers: 1,2,3,4,5,6,7,8,9.
Write a single query that returns the median value of the 10rows of TableA.
The same query should also work for Table B and return themedian value of the 9 rows in Table B.
Expected Answers:
Median for Table A: 5.5
Median for Table B: 5
It would be really helpful if you could include screenshots.Thanks!
