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 are the types of partitions in oracle?

1076

Explain the truncate in oracle?

1009

What is the usage of save points in oracle database?

1011

What is clustered table in Oracle?

1257

if you ctreate table identity

2426

How to rebuild an index in oracle?

1069

Can we use bind variables in oracle stored procedure?

983

How to use "startup" command to start default instance?

1099

What are the major difference between truncate and delete?

1130

Explain the difference between sap and oracle?

1081

what is dynamic SGA and static SGA

4481

Explain an integrity constrains?

1190

Can you drop an index associated with a unique or primary key constraint?

1067

How will you identify oracle database software release?

1053

What are the ways tablespaces can be managed and how do they differ?

2440