We are looking for Marketing and Operations Executives

Job Description
1) Marketing Executive - Look for new business and work towards growth of the agency.

2) Operation Executive - Conduct events and support in day to day activities.
Salary:As per candidate.
Industry:Advertising, PR, MR, Event Management
Functional Area:Marketing, Advertising, MR, PR, Media Planning
Role Category:Marketing
Role:Direct Marketing Executive
Keyskills:marketing, operations, ops, sales operations, business development, Event Management, Event Marketing, events, MBA

Desired Candidate Profile
Education:(UG - Any Graduate - Any Specialization) OR (PG - Any PG Course) AND ( Doctorate - Doctorate Not Required)
Graduates, MBA Fresher, Management Trainees (Courses in Marketing , preferred.)
Company Profile
Xpressif Events
http://www.xpressifevents.com/
Xpressif Events is service providing agency with offices in Punjab, New Delhi and Gujarat.
We specialize in providing all sorts of event management and media planning services.

How to find out Max Salary from each department

You can find maximum salary for each department by grouping all records by DeptId and then using MAX() function to calculate maximum salary in each group or each department. SQL Query: SELECT DeptID, MAX(Salary) FROM Employee GROUP BY DeptID. This questions become more interesting if Interviewer will ask you to print department name instead of department id, in that case you need to join Employee table with Department using foreign key DeptID, make sure you do LEFT or RIGHT OUTER JOIN to include departments without any employee as well. Here is the query

List the emps who joined before 1981.

Answer: select * from emp where hiredate < (’01-jan-81’);

SQL Info

Search This Blog