Question

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.12 1.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 1

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

2. sqlpractice=# SELECT *

sqlpractice-# FROM salesown;

salesman_id | name | city

-------------+--------------+----------

5002 | Nail Knite | Paris

5005 | Pit Alex | London

5006 | Mc Lyon | Paris

5003 | Lauson Hense |

5007 | Paul Adam | Rome

5001 | James Hoog | New York

(6 rows)

Answer