Hiii try this query you will get the answer select count(1) as Sales

Table - Products has number of products as below
Productid ProductName
1
iPhone
2
iPad
3
BlackBerry

Table - SalesPersonProduct has the
below records
Salespersonid
productid
S1
1
S1
2
S1
3
S2
1
S3
2

Write a SQL query that returns the number of sales for each
product

Question Posted / madhu sudhan g

2 Answers
6632 Views
I also Faced
E-Mail Answers

Answer Posted / madhu sudhan g

Hiii

try this query you will get the answer

select count(1) as SalesCount,P.Product from Products P
INNER JOIN SalesPersonProduct S ON S.Id=p.Id group by P.Product

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are data driven subscriptions?

115

How to use group functions in the select clause in ms sql server?

1058

When is the use of update_statistics command?

1009

What is a trigger and its types?

994

Is sql server difficult to learn?

924

What is row_number function?

1013

What is the use of group by clause?

944

Explain sql server service broker?

981

Comment,Datatypes are unlimited

2065

How to get the number of affected rows?

1007

What is SQL Server?

1219

What is 2nf example?

1000

What is the difference between DATETIME2 and DATETIME?

1085

Explain concepts of analysis services?

964

What the difference between UNION and UNIONALL?

1041