From the Salesman and Customer tables below, write SQL statements following: do the a) List the salesman id, rating and names of those salesmen who get rating from 3 to 5, sorted DESCENDING by rating. 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 Italy 2005 James hood 2 Canada 2045 Paul Hen 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 Jаpan 2045 Johnson UK 2010 Jozy Altidor 100 5 Brad Guzan 500 Canada 2005

From the Salesman and Customer tables below, write SQL statements following: do the a) List the salesman id, rating and names of those salesmen who get rating from 3 to 5, sorted DESCENDING by rating. 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 Italy 2005 James hood 2 Canada 2045 Paul Hen 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 Jаpan 2045 Johnson UK 2010 Jozy Altidor 100 5 Brad Guzan 500 Canada 2005

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

Similar questions

Given the binary of an IP address, 11000000.10100111.00001010.00000100, please provide the decimal IP address.
I’ll be sure to thumbs up! Thanks
How many international direct-dialing numbers are possible if each number consists of a four-digit area code (the first digit of which must be nonzero) and a five-digit telephone numbers (the first digit must be nonzero)?
What exactly is the Domain Name System, sometimes known as DNS? Could you kindly fill me in on the specifics?
Pls help ASAP.
Given the binary of an IP address,00001010.00000100.00011100.00010011, please provide the decimal IP address.
Which emailSet the Scene Your solution is here.
Please help me figure out right one I have marked mine but still want to double check
write a response to the following prompt. Your prompt should quote from Blown to Bits 253-257, and be at minimum 4 paragraphs. Why should people in the United States care about Internet rules in other countries?
How can you tell whether a website has a unique identifier? A mnemonic address is a way to remember a certain place. How many domains may be represented by 32 bits? What is it, if this is the case?
What exactly does it imply when someone says the letters "DNS"? Could you elaborate?
Who is responsible for adding new entries to the forwarding table? There are two options for updating the forwarding table. .