Scribd
Upload
6 views2 pages

Chatbot Training Column

The document contains a series of queries related to employee data management, focusing on various departments, salary ranges, and specific conditions. It includes requests to list employees by department, filter by salary thresholds, and aggregate data such as average salary and employee counts. The queries aim to extract detailed information about employees across multiple departments, emphasizing salary and departmental associations.

Uploaded by

amirul.iuk.ai
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
6 views2 pages

Chatbot Training Column

The document contains a series of queries related to employee data management, focusing on various departments, salary ranges, and specific conditions. It includes requests to list employees by department, filter by salary thresholds, and aggregate data such as average salary and employee counts. The queries aim to extract detailed information about employees across multiple departments, emphasizing salary and departmental associations.

Uploaded by

amirul.iuk.ai
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 2

Show all employees in the department

List employees from the sales department


Find employees with salary greater than 50000
Get employee names and salaries from the marketing department
Display employees where salary is less than 60000
Show employee name, department, and salary
Find employees in the HR department with salary above 40000

List employee names in the IT department

Find employees with salary between 40000 and 70000

Show employees in department sales with salary greater than 50000

Employees who have salary less than 30000 and work in accounting

Find employees where department is marketing and salary greater than 45000

Show employees with salary not equal 60000

Get employees with salary greater or equal 55000 in department HR

Show average salary by department

Find max salary in each department

Get count of employees in each department

Show total salary paid in the finance department

Display department name and average salary of employees

List departments with employee count greater than 10

List employees in the sales department ordered by salary desc

Show top 5 highest paid employees in HR

Find employees with salary greater than 40000 ordered by salary asc

Show last 10 employees hired in the marketing department ordered by hire date
desc

Show employee name and department name where salary is above 60000

List employees with department.name and salary greater than 50000

Display employee name, salary, and department address

Get employee salary details from department sales

Search employees in the finance department with salary over 70000

Find staff from HR department with salary greater than 40000

Look for employees in department marketing earning more than 55000

Find employees with salary > 50000 or in department IT


Show employees where department = Sales and salary < 60000

List employees with salary > 45000 and department not equal HR

Find employees with salary between 40000 and 60000 or in marketing department

You might also like