How many delivery personnel have called customers more than 5 times?

AnswerBot
1y

The number of delivery boys who called customers more than 5 times is not provided.

  • Data on the number of delivery boys who called customers more than 5 times is missing.

  • Need to gather data on the numb...read more

Anonymous
5mo
Yes
Yogesh Kumar
1y
Yes
Nachiket Asare
1y

Use chat gpt for my justification.

1)Select * from customers c inner join orders o on c.customerid=o.customerid where count(o.orderid)>5;

2) Select * from customers c inner join orders o on c.customerid...read more

Yogesh Kumar
1y
Yes
Anonymous
1y

Select count( distinct delivery boy) from (select delivery_boy, customer, count(call) as cnt from db.table

Group by 1,2

Having cnt > 5)

Add answer anonymously...

Swiggy Business Analyst interview questions & answers

A Business Analyst was asked 7mo agoQ. What is skewness and what are its types?
A Business Analyst was asked 7mo agoQ. How do you handle outliers?
A Business Analyst was asked 7mo agoQ. What is the difference between DDL and DML?

Popular interview questions of Business Analyst

A Business Analyst was asked 7mo agoQ1. What is skewness and what are its types?
A Business Analyst was asked 7mo agoQ2. How do you handle outliers?
A Business Analyst was asked 25 Sep 2022Q3. Count the distinct unique names from the table.
Swiggy Business Analyst Interview Questions
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter