What is the intention of this select statament

[sekitoleko]

SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary >= 2500 and job-id like '%MAN%';

[ScarletPimpernal]

To get all the Job-id with characters MAN and the salary greater than or equal to 2500.

That is,

The table has values

employee_id--last_name--job-id--salary
-------------------------------------------------------
1--person1--aman--3000
2--person2--bman--3500
3--person3--cman--1000
4--person4--dman--4000
5--person5--no--3000
6--person6--not--3000

Then the query u given will list the records

employee_id--last_name--job-id--salary
-------------------------------------------------------
1--person1--aman--3000
2--person2--bman--3500
4--person4--dman--4000

I think this will be fine to understand

Thanks,
Scarlet.

SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary >= 2500 and job-id like '%MAN%';

[sekitoleko]

Thanks Scarlet,I was confusing job_id with employee_id and wondering how employee_id could take on characters.