Table name:salesmansalesman_id | name | city | commission ------------

1.	Table name:salesmansalesman_id \| name \| city \| commission -------------+------------+----------+------------5001 \| James Hoog \| New York \| 0.155002 \| Nail Knite \| Paris \| 0.135005 \| Pit Alex \| London \| 0.115006 \| Mc Lyon \| Paris \| 0.145007 \| PaulAdam \| Rome \| 0.135003 \| Lauson Hen \| San Jose \| 0.121.Write a SQL statement to display all the information of all salesmen.2.Write a SQL statement to display name and commission for all the salesmen.3.Write a SQL statement to display names and city of salesman, who belongs to the city of Paris.
Answer» Answer: 1. SQL QUERY for DISPLAY all the information of all salesmen select salesman_id, NAME, city, commission from SALESMAN or select * from salesman 2. SQL Query for display name and commission for all the salesmen select name, commission from salesman 3. SQL Query for display names and city of salesman, who belongs to the city of Paris select name, city from salesman where city = 'Paris'

Table name:salesmansalesman_id | name | city | commission -------------+------------+----------+------------5001 | James Hoog | New York | 0.155002 | Nail Knite | Paris | 0.135005 | Pit Alex | London | 0.115006 | Mc Lyon | Paris | 0.145007 | PaulAdam | Rome | 0.135003 | Lauson Hen | San Jose | 0.121.Write a SQL statement to display all the information of all salesmen.2.Write a SQL statement to display name and commission for all the salesmen.3.Write a SQL statement to display names and city of salesman, who belongs to the city of Paris.

Answer»

Answer:

1. SQL QUERY for DISPLAY all the information of all salesmen

select salesman_id, NAME, city, commission from SALESMAN

select * from salesman

2. SQL Query for display name and commission for all the salesmen

select name, commission from salesman

3. SQL Query for display names and city of salesman, who belongs to the city of Paris

select name, city from salesman where city = 'Paris'