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 coalesce function?

565

What is ADDM Advisor in Oracle?

652

How will you write a query to get a 5th rank student from a table student_report?

1353

What is parameterized cursor in oracle?

566

Explain temporal data types in oracle

597

How do I spool to a csv formatted file using sqlplus?

538

Explain parameter file in oracle.

572

Can we store images in oracle database?

541

How to create a table index in oracle?

646

What is the difference between substr & instr functions?

591

How are extents allocated to a segment?

571

What is analyze command used for?

569

Explain drop constraint oracle?

589

What is a view and how is it different from a table?

566

What is key preserved table?

556