Query to find all cars sold by salesman

[sreekumar_nair_it]

find sales person who sold all car brands in a year

I want to display the sales dealer who sold all the car brands for the present year.

car brand may change year to year ie this may keep on increasing. i like to write a sql query which fetches data without using any hard code values on brand name.

Dear gangu_d,

Please provide sample data.
It will be easy for our team members to help you better.
Also send the structure if possible.

Have a pleasant time.