from product as p --using join select p.pid, p.pname, count (o.productid)as Total_Order from product as p inner join ProductOrder as o on p.pid=o.productId group by p.pname,p.pid -- sub Query to ...

A subquery is also known as an inner query or nested query, is a query nested within another SQL query. It allows you to retrieve data from one or more tables based on the result of a SELECT ...

A nested subquery is a query inside another SQL statement that does not reference any column from the outer query. A correlated subquery is a subquery that references columns from the outer query.