Salesman table: Salesman Salesman_ rating country _id name 2001 Mc Lyon 3 Italy 2005 James hood Canada 2045 Paul Hen 6 USA 2010 Nail Alex 4 France 2060 Salm E 5 KSA Customer table: Cust_id Cust_nam...

Question One

From the Salesman and Customer tables below, write SQL statements to do the following:

1. List the salesman id, rating and names of those salesmen who get rating from 3 to 5, sorted DESCENDING by rating.


2. List all the customers’ information whose name starts with ‘F’ and the fourth character is ‘I’, rests may be any character.


3. List the name and country of those customers and salesmen who belongs to the same country.

Extracted text: Salesman table: Salesman Salesman_ rating country _id name 2001 Mc Lyon 3 Italy 2005 James hood Canada 2045 Paul Hen 6 USA 2010 Nail Alex 4 France 2060 Salm E 5 KSA Customer table: Cust_id Cust_nam grade country Salesman _id e 1 Nick 100 France 2010 Rimando 2 Brad Davis 400 Canada 2005 3 Fabian 200 Japan 2045 Johnson 4 100 UK 2010 Jozy Altidor Brad Guzan 500 Canada 2005