From the following table, write a SQL query to find the details of those salespeople who come from any of the City 'Paris' or 'Rome'

hamza

Save to bookmark

2022-05-18

114

From the following table, write a SQL query to find the details of those salespeople who come from any of the City 'Paris' or 'Rome'. Return salesman_id, name, city, commission.

Sample table: salesman

salesman_id |    name    |   city   | commission 
-------------+------------+----------+------------
        5001 | James Hoog | New York |       0.15
        5002 | Nail Knite | Paris    |       0.13
        5005 | Pit Alex   | London   |       0.11
        5006 | Mc Lyon    | Paris    |       0.14
        5007 | Paul Adam  | Rome     |       0.13
        5003 | Lauson Hen | San Jose |       0.12

Sql programming,

All Answers

hamza

2022-05-18

need an explanation for this answer? contact us directly to get an explanation for this answer

SELECT * 
FROM salesman 
WHERE city IN('Paris','Rome');

Output of the Query:

salesman_id	name		city	commission
5002		Nail Knite	Paris	0.13
5006		Mc Lyon		Paris	0.14
5007		Paul Adam	Rome	0.13

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

From the following table, write a SQL query to find the details of those salespeople who come from any of the City 'Paris' or 'Rome'

All Answers

Similar questions

need a help?

find thousands of online teachers now