a)+Listthe salesman id, rating and names of those 'salesmen who ʻgetrating from 3 to:5, sorted DESCENDING-by-fating. b)-List all- the customers' information whose name starts with 'F' and the fourth- character is I', rests'may-be any-character. c)»List the name and country of those customers and salesmen who belongs to-the-same- country.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
100%
From: the Salesman and Customer tables· below, write SQL· statements to· do: the
following: 1
a)+List the salesman id, rating and names of those salesmen who 'get-rating from 3 to:5,
sorted DESCENDING·by:rating.1
b)+List all- the- customers' information: whose name starts with: 'F' and the fourth:
character-is I',rests•may·be any character.
c)+List the name and country of those customers and salesmen who belongs to the same
country.
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
e
id
1.
Nick
100
France
2010
Rimando
2
Brad Davis
400
Canada
2005
3
Fabian
200
Japan
2045
Johnson
4
Jozy
100
UK
2010
Altidor
5
Brad Guzan
500
Canada
2005
Transcribed Image Text:From: the Salesman and Customer tables· below, write SQL· statements to· do: the following: 1 a)+List the salesman id, rating and names of those salesmen who 'get-rating from 3 to:5, sorted DESCENDING·by:rating.1 b)+List all- the- customers' information: whose name starts with: 'F' and the fourth: character-is I',rests•may·be any character. c)+List the name and country of those customers and salesmen who belongs to the same country. 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 e id 1. Nick 100 France 2010 Rimando 2 Brad Davis 400 Canada 2005 3 Fabian 200 Japan 2045 Johnson 4 Jozy 100 UK 2010 Altidor 5 Brad Guzan 500 Canada 2005
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY