select c.cust_id,
c.company_name,
(select count(order_id) from orders
union
select count(order_id) from orderdetails)
from Orders o,
Customer c,
OrderDetails od;
select c.cust_id,
c.company_name,
(select count(order_id) from orders
union
select count(order_id) from orderdetails)
from Orders o,
Customer c,
OrderDetails od;