Question

Salesman_id Name City Commission
5001 JamesHoog New York 0.15
5002 NailKnite Paris 0.13
5005 Pit Alex London 0.11
5006 McLyon Paris 0.14
5007 Paul Adam Rome 0.13

a) Write a SQL statement to display all the information of all salesmen (3 marks)
b) Write a SQL statement to display specific columns like name and commission for all the salesmen. (3 marks)
c) Write a SQL statement to display names and city of salesman, who belongs to the city of Paris. (4 marks)
d) Write a SQL statement to find those salesmen with all other information and name started with letter 'P' (4 marks)
e) Write a query to filter those salesmen who come from any of the cities Paris and Rome. (4 marks)
f) Write a query to produce a list of salesman_id, name, city and commission of each salesman who live in cities other than Paris.(2 marks)
g) Write a SQL statement to find those salesmen with all information who gets the commission within a range of 0.12 and 0.14 (3 marks)
h) Write a SQL statement to find all those salesmen with all information whose names are ending with the letter 'n'. (2 marks)

Answer 1

Answer:

belive in youreslf and you can do it .

Explanation: