Question OneFrom the Salesman and Customer tables below, write SQL statements to do the following: List the salesman id, rating and names of those salesmen who get rating from 3 to 5, sorted DESCENDING by rating.List all the customers’ information whose name starts with ‘F’ and the fourth character is ‘I’, rests may be any character.List the name and country of those customers and salesmen who belongs to the same country. Salesman table:Salesman Salesman_ratingcountry_idname2001Mc Lyon3Italy2005James hoodCanada2045Paul Hen6USA2010Nail Alex4France2060Salm E5KSACustomer table:Cust_idCust_namgradecountrySalesman_ide1Nick100France2010Rimando2Brad Davis400Canada20053Fabian200Japan2045Johnson4100UK2010JozyAltidorBrad Guzan500Canada2005

Given : - A salesman table and a customer table Need to write down the sql queries (or…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Question One

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

List the salesman id, rating and names of those salesmen who get rating from 3 to 5, sorted DESCENDING by rating.
List all the customers’ information whose name starts with ‘F’ and the fourth character is ‘I’, rests may be any character.
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
_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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions