SELECT B.Region FROM TABLE1 AS A INNER JOIN TABLE2 AS B ON A.EmployeeID=B.

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

Question Posted / sandeep narayanan

15 Answers
16449 Views
Google, I also Faced
E-Mail Answers

Answer Posted / sandeep narayanan

SELECT B.Region FROM TABLE1 AS A
INNER JOIN TABLE2 AS B ON A.EmployeeID=B.EmployeeID
WHERE A.TShirtSize=3

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to create a scrollable cursor with the scroll option? : Sql server database administration

1028

Explain what is analysis service repository?

931

What is table valued function and scalar valued functions?

993

Can we update data in a view?

974

Explain what stored procedure sp_replcounters is used for? : sql server replication

1455

What are some examples of schemas?

915

What is raid, and how it can influence database performance?

1011

How can we rewrite sub-queries into simple select statements or with joins?

926

What is the new security features added in sql server 2014? : sql server security

946

What are user-defined functions (udfs) in sql server?

937

What is subquery explain with example?

1012

What are xml indexes?

895

Explain database normalization?

1152

Tell me the phases a transaction has to undergo?

918

Can a table have 2 primary keys?

934