Assuming that we have 2 tables - customers and orders:
Which of the following queries is correct to count the customers who have put at least one order?

Question

Assuming that we have 2 tables - customers and orders:  
 Which of the following queries is correct to count the customers who have put at least one order?

Answer

select count(distinct customers.customers_id) from customers join orders on orders.customer_id = customers.customers_id;

Answer

select count(*) from customers join orders on orders.customer_id = customers.customer_id;

Crowdly

Assuming that we have 2 tables - customers and orders: Which of the following...

Want instant access to all verified answers on softserve.academy?