Subject : Database Concept and design

Given a database as below: Write a query to the following scenarios: a) Display name and commission for all the salesmen [2 marks] b) Show the winner of the 1971 prize for Literature. [2 marks] c) Find all those customers with all information whose names are ending with the letter ' n '. [3 marks] d) Display the order number, order date and the purchase amount for order(s) which will be delivered by the salesman with ID 5001. [4 marks] e) Retrieve salesman id of all salesmen from orders table without any repeats. [4 marks] f) Find customer in which the salesman who worked for him was from Paris and his purchased amount is more than $2000. Return Customer Name name as "Customer", Salesman name name as "Salesman", and Purchase amount Name as "Total Purchase". [5 marks]