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 total number of sold products


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More MySQL Interview Questions

What are procedures in mysql?

0 Answers  


what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

0 Answers  


What is data directory in mysql?

0 Answers  


How to delete an existing column in a table?

0 Answers  


What is a storage engine?

0 Answers  






How do stored procedures work?

0 Answers  


How to Change a users password from unix shell.

0 Answers  


What are some good ideas regarding user security in MySQL?

2 Answers  


What is difference between statement and preparedstatement?

0 Answers  


How do I create a schema in mysql?

0 Answers  


What do I do if I forgot my mysql root password?

0 Answers  


What is the query to display top 20 rows?

0 Answers  


Categories