Ques.1 How many delivery boy 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
22d
Yes
Yogesh Kumar
11mo
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
11mo
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
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
Get AmbitionBox app

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