From the following table, create a view to find the salespersons of the city 'New York'

hamza

Save to bookmark

2022-05-18

127

From the following table, create a view to find the salespersons of the city 'New York'.

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

CREATE VIEW newyorkstaff
AS SELECT *
FROM salesman
WHERE city = 'New York';

Code to see the records form the view

SELECT *
FROM newyorkstaff
WHERE commission > .13;

output:

sqlpractice=# SELECT *
sqlpractice-# FROM newyorkstaff
sqlpractice-# WHERE commission > .13;
 salesman_id | name       |   city   | commission
-------------+------------+----------+------------
        5001 | James Hoog | New York |       0.15
(1 row)

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

total answers (1)

From the following table, create a view to find the salespersons of the city 'New York'

All Answers

Similar questions

need a help?

find thousands of online teachers now