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
17012 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

What are the differences between web role and worker role?

122

What do you understand by sql server agent?

980

What are pages and extents? : SQL Server Architecture

1021

How to create a new schema in a database?

1154

How to create nested stored procedure?

1026

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

996

What is a fan-out query in SQL Azure?

121

What is open database communication (odbc)?

1069

What is sharding?

116

How can I create a new template for import ? : sql server management studio

1078

How to insert a new row into a table with "insert into" statements in ms sql server?

979

what are different types of raid configurations? : Sql server database administration

1067

What is model database in sql server?

1056

What is the name of the system variable that returns the number of rows affected by a SQL statement?

1020

What is a group function explain with an example?

993