Interview Questions Answers in SQL Server

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, 16449 }

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