Hi how to write a query to know who is the employee who made more number of sales using joins with customer table
Loading
Hi how to write a query to know who is the employee who made more number of sales using joins with customer table
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Raghu GPosted Sep 5, 2022, 12:17 PM
i am trying this in postgre and mysql.
@Rajnikant your query not returning any data, thanks for your time
@Uday can you help me?
employee table
customer table
Orders table
OrdersDetails table
Products tabel
ProductLines table
Payment table
Rajanikant HawaldarPosted Sep 5, 2022, 11:56 AM
Uday DodiyaPosted Sep 5, 2022, 11:42 AM