ram


{ City } chennai
< Country > india
* Profession *
User No # 17001
Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 1
Users Marked my Answers as Wrong # 10
Questions / { ram }
Questions Answers Category Views Company eMail




Answers / { ram }

Question { Google, 14124 }

can any one answer this query,thank you in advance

Table 1 has 2 columns: EmployeeId, T shirtsize(values can
be 1,2,3)
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region which has the largest number
of people with Tshirt size=3


Answer

select region from tab2 where empid in(select empid from
tab1 where tshirtsize=3)

Is This Answer Correct ?    1 Yes 10 No