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

Explain the types of exception?

1081

How to assign values to variables?

1043

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2574

How to create a table interactively?

996

What is the difference between 10g OEM and 11g OEM?

916

How to use windows user to connect to the server?

934

What is a static data dictionary in oracle?

1023

What are the roles of dba?

1018

How can we delete duplicate rows in a table?

926

Explain an integrity constrains?

1076

Does oracle database need java?

940

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2188

How to define an anonymous procedure without variables?

1022

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1869

How to add a new column to an existing table with a default value?

965