From the Salesm an and Customer tables below, write SQL statements to do thefollowing:a) List the sales man id, rating and names of those sales men who getrating from 3 to 5,sorted DESCENDING by rating.b) List all the customers' informat ion whose name starts with 'F' and the fourthcharacter is T, rests may be any charac ter.c) List the name andcountry of those customers and sales men who belongs to the samecountry.Salesman table:Salesman Salesman_ rating_idcountryname2001Mc Lyon3Italy2005James hood2Canada2045Paul HenUSA2010Nail Alex4France2060Salm E5KSACust omer table:Cust_idCust_namgradecountrySalesmane_id1Nick100France2010Rimando2Brad Davis400Canada20053Fabian200Japan2045Johnson4UKJozyAltidor10020105Brad Guzan500Canada2005

From the Salesman and Customer tables below, write SQL statements to do th following: a) List the sales man id, rati ng and names of those sales men who getrati ng from 3 to sorted DESCENDING by rati ng. b) List all the customers' informat ion whose name starts with 'F' and the foun character is T, rests may be any character. c) List the name and country of those customers and sales men who belongs to the sam country. Salesman table: Salesman Salesman_ _id rating country name 2001 Me Lyon 3 Italy 2005 James hood 2 Canada 2045 Paul Hen 6 USA 2010 Nail Alex 4 France 2060 Salm E 5 KSA Cust omer table: Cust_id Cust_nam country Salesman _id grade 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

From the Salesman and Customer tables below, write SQL statements to do th following: a) List the sales man id, rati ng and names of those sales men who getrati ng from 3 to sorted DESCENDING by rati ng. b) List all the customers' informat ion whose name starts with 'F' and the foun character is T, rests may be any character. c) List the name and country of those customers and sales men who belongs to the sam country. Salesman table: Salesman Salesman_ _id rating country name 2001 Me Lyon 3 Italy 2005 James hood 2 Canada 2045 Paul Hen 6 USA 2010 Nail Alex 4 France 2060 Salm E 5 KSA Cust omer table: Cust_id Cust_nam country Salesman _id grade 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

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...

See similar textbooks

Related questions

Q: Display the list of students who are involved in the IT club Display the details of all the…

A: First get the studid from Club table and then get those Student details This can be done using inner…

Q: Execute the SQL statement. SELECT count(*) as "Total Customers" FROM customers; SELECT…

A: SELECT count(*) as "Total Customers"FROM customers; SELECT count(distinct category_name) as…

Q: Please see the attached sql function question requiring an sql function to be written to calculate a…

A: alter session set plsql_code_type=native; CREATE FUNCTION mortgage_rate( p_principal…

Q: Just let me know what to write for the SQL theory: Question: Write a query to display the first…

A: Solution: Given,

Q: Write SQL statement that retrieve the department_name that has the maximum number of employees:…

A: The given is the requirement to find the department_name from depart table for the department that…

Q: a) Write an SQL query to find the manufacturer and model for all aircraft models with capacity at…

A: a) SELECT Manufacturer , Model FROM Aircraft_Models WHERE Capacity>=300 ; b)…

Q: Write the relational algebra formula to apply an INTERSECT relational operator to the tables

A: Relational algebra formula for Intersect Relational Operator: An Intersect relational operator…

Q: use the picture below (the data has been shown) to create a sql statement that will enter the…

A: To create a SQL statement to enter the record into the table named PART. The attributes of the…

Q: Write a SQL code that returns the Name of ALL Customers (based on CUS_FNAME and CUS_LNAME in…

A: The question is solved in step2

Q: We have employee table contains (emp-no, emp-name, emp-age, emp-salary, emp-department) write a…

A: Given Employee table contains the attributes: emp_no, emp_name, emp_age, emp_salary, emp_department

Q: . Write SQL statements to create a table named STUDENT, with the following columns: StdID:…

A: In this question we have to write SQL QUERY for the given table name STUDENT.Let's query and hope…

Q: simplifying conditional logic in SQL?

A: The CHOOSE function is a powerful tool in SQL that simplifies conditional logic by allowing…

Q: The first requirement: Using the SQL language, transform the following entity model into tables in…

Q: Consider the following expressions, which use the result of a relational algebra operation as the…

Q: Write an sql query to show country code, country name of those employees whose country name…

A: Please refer below for your reference: Queries: 1.SELECT country code, country name FROM employees…

Q: Write SQL queries for the following database: id Customers name email Categories id name id…

A: Since there are multiple parts to a single question, the first three subparts are answered for you.…

Q: Write PL/SQL or T-SQL procedures to accomplish the following tasks: A: obtain the name and credit…

A: Actually, SQL stands for Structured Query Language.

Q: Write SQL statements to solve the following queries: - (a) Show the total number of students in…

A: Note: As per our company policy, only the first three subparts are answered. Please repost the…

Q: Can you Write the SQL statements to do the following please : 1. Display the artist's name from the…

A: Note:- As per our policy , we can solve only 3 sub-parts. Please post remaining one. Upper() :-…

Q: Write a function and a call program in PL/SQL to sum the even integers between 1 and any number that…

A: given to write pl/sqlprocedure function for sum of 1 to n even numbers: Below is the procedure of…

Q: QUESTION Given the sample of the GPADatabase in a file, write SQL Stored function called…

A: Steps to create a SQL stored function to calculate the semester GPA: Step – 1: Connect to your SQL…

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Q: 51. The given SQL statement is intended to either (1) list the customer numbers, customers names,…

A: Given SQL query: SELECT CUSTNUM, CUSTNAME, HQCITY FROM CUSTOMER WHERE HQCITY= 'Los Angeles' Given 2…

Question

From the Salesm an and Customer tables below, write SQL statements to do the
following:
a) List the sales man id, rating and names of those sales men who getrating from 3 to 5,
sorted DESCENDING by rating.
b) List all the customers' informat ion whose name starts with 'F' and the fourth
character is T, rests may be any charac ter.
c) List the name andcountry of those customers and sales men who belongs to the same
country.
Salesman table:
Salesman Salesman_ rating
_id
country
name
2001
Mc Lyon
3
Italy
2005
James hood
2
Canada
2045
Paul Hen
USA
2010
Nail Alex
4
France
2060
Salm E
5
KSA
Cust omer 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
UK
Jozy
Altidor
100
2010
5
Brad Guzan
500
Canada
2005

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Write all the sql code (including create, insert and select)
(b) Consider the schema of Customer table and write SQL statements for the following queries. cid sname address age occupation salary Payment mode gender 123 sam xacoas 31 manager 60000 cash 124 david flaca 38 administrator 45000 credit i. Write the SQL code to list details of clients in descending order of the salary. ii. Write the SQL code to show details of clients whosere salary is greater than Rs 45000 and age is between 35 and 45.
Consider the following expressions, which use the result of a relational algebra operation as the input to another operation. For each expression, explain in words what the expression does. a. year 2009 (takes) ▷ student b. year 2009 (takes ▷ student) C. ID.name, course_id (student takes)
For below DEPARTMENT table write a SQL query so that repeated group names are shown with quotation symbol like in above desired output For understanding logic, can you give simple example in Microsoft SQL Server Management Studio 18. Thank you.
Consider the tables provided below and answer the following SQL questions: Table 1: Service SereicelD SereiceName Accounting. Security Maintenance Table 2: ServiceSetUp SereicelD SetupFee 2 3 4 100 300 350 Recurring 25 50 125 Tax 10% 11 9% Questions: Write insert statements to enter first two records into Table 1 as shown in above figure. Display a list that presents the data contained in Table 1 sorted by column 2 in descending order. Display the name of the service that has setup fee greater than $300. d. Display average of tax rates for all services.
Based on SQL query knowledge
I need help on this problem: Write an SQL query that displays the therapies and their unit of time for the therapies that include the word bath, hot, or electrical.
Could you please answer all the quastion please ASAP?
Write a SQL code that returns the name of aircraft (MOD_NAME in MODEL table), number of trips each mode flied (based on the CHARTER table, name this Trip_Num), and Total distance of each mode (based on the CHARTER table, name this Total_Distance).
(b) Consider the schema of Customer table and write SQL statements for the following queries. sid sname address age occupation salary Pavment mode gender 123 sam yacoas 31 manager 60000 cash 124 david flaca 38 administrator 45000 credit i. Write the SQL query to set salary of all supervisors to Rs 40 000. ii. Write the SQL query to display details of clients whose names end with character 'e'. iii. Write the SQL code to display details of those clients who come from Vacoas or mahebourg,
SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 800 100 SalesRepNo 345 434 654 345