select c.custid,c.name,count(o.ordid) from customer c left join orders o o

7. Repeat query (7) but also display all clients who have
never ordered anything.

Question Posted / anjum

Answer Posted / anjum

select c.custid,c.name,count(o.ordid) from customer c left
join orders o on c.custid=o.custid group by c.custid;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is meant by raw datatype?

1119

What are the system predefined user roles?

1100

What is a relational database management system?

1173

How to drop a stored procedure in oracle?

1107

Which is faster join or subquery in oracle?

1050

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

2049

What is a user account in oracle?

1173

What is Trigger in Oracle?

1244

What are the uses of Database Trigger ?

1789

How remove data files before opening a database?

1135

What is oracle thin client?

1076

What is an oracle transaction?

1229

What is merge statement used for?

1076

Explain oracle instance.

1234

How to change user password in oracle?

1099