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

Q: From the Salesman and Customer tables below, write SQL statements following: do the a) List the…

A: 1) select salesman_id,salesman_name,rating from salesman where rating between 3 and 5 order by…

Q: Write SQL queries for the following statements (Use only Cartesian product and join)…

A: Hey there, I am writing the required solution for the above stated question.  I can only answer one…

Q: Indicate for each of the following SQL statements, how many tuples would be returned  if it was run…

A: Answer : Here, the table is given so we need to find out the answers to given queries: I have…

Q: • Write an SQL query to print details for employees with the first_name as "“Lex" and "Den" from…

A: PART1: SELECT * FROM EMPLOYEE  WHERE  first_name ="Lex" AND first_name="Den";

Q: es in relational algebra. Find the username of users who are from ‘Muscat’. Find the IDs of pictures…

A: 1. Find the username of users who are from ‘Muscat’ SELECT username FROM users where place='Muscat'…

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: Answer: 22114454

Q: Write SQLSQL statements for following: Student( Enrno, name, courseId, emailId, cellno)…

A: We need to create tables for Student and Course And we need to insert values into these tables.…

Q: Based on the above tables, write the SQL statements for each of the following operation: 1. Create…

A: According to the asked question, the solution is given below with a proper explanation. Keeping a…

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: According to the asked question, the solution is given below with a proper explanation.

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: Answer :--  Jan-12-01

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: Answer: 98877445

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: NVL2(expr1, expr2, expr3) : The NVL2 function examines the first expression. If the first expression…

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: While executing sql command firstly it performs where condition,here we have per_test='positive' In…

Q: Write an SQL statement that find and display Warehouseld, Total number of SKU, Summation of…

A: In this question, we have to find out an SQL statement which will display the desired data. We have…

Q: Write the following subqueries for these statements in SQL using this ERD diagram   1.…

A: “Since you have posted a question with multiple sub-parts, we will solve first three subparts for…

Q: Product(pid, name, type, manufacturer, price), Buys(cid, pid), Customer(cid, cname, age, gender) a)…

A: a) π(Customer) (( σ(Product.manufacturer = 'Sears' Product) ⋈ Customer ⋈ Buys )

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: COALESCE returns the first non null value in the list. Here in the fax column, the blood_type is A…

Q: d) Write the following guery in sQL Find the names of all shicents who arc not enrolled in any…

A: SELECT DISTINCT S.sname FROM Student S WHERE S.sid NOT IN (SELECT E.sid…

Q: Write the SQL statements to satisfy the requests below A customer service representative is trying…

A: To Do: To write the SQL statement.

Q: b. Write SQL queries for the following statements. i. Display all the product's details in the…

A: b. 1. SELECT p.p_ID,p.p_Name,p.p_colour FROM Product p INNER JOIN Catalog c ON c.p_ID=p.p_ID  ORDER…

Q: (a) Customer(cid, cname, address, age, occupation, salary, payment_mode) Where cid is the primary…

A: Answer to the above question is in step2.

Q: Write SQL statements and relation algebra for following: Student( Enrno, name, courseId, emailId,…

A: The SELECT statement is a DML(data manipulation language ) command used to retrieve desired columns…

Q: Write SQL statements and relation algebra for following: Student( Enrno, name, courseId, emailId,…

A: This activity is utilized to select lines from a table (connection) that indicates a given…

Q: 8. Write a Relational Algebra expression to represent the following SQL statement: select building,…

A:

Q: Write SQL statements for the following queries: Retrieve First_Name , Salary, department Name and…

A: Retrieve First_Name , Salary, department Name and Location_Name  for all employees sorted by…

Q: Student Student d Name Birthdate 100 Sara John 01-01-1999 200 Sami Salim 01-02-2000 300 Rola Ahmad…

A: Hello Student. Warm welcome from my side. Hope you are doing great. I will try to give the best…

Q: Write queries in SQL to answer each of the following questions:…

A: Ques 1. Find all instructors in Finance department who have taught some course in 2008.   Tables…

Q: Test your Procedure with the following data: AthleteID= 10, First_Name = ‘Frankie’, Last_Name =…

A: Given: Test your Procedure with the following data: AthleteID= 10, First_Name = ‘Frankie’, Last_Name…

Q: Write SQL statements to the following queries. Retrieve PRODUCT_NAME for the second maximum product…

A: SUBQUERY   A Subquery is also…

Q: Write SQL statements to the following queries. Retrieve PRODUCT_NAME for the second maximum product…

A: Subquery is a method of querying from database when a low level query is used inside a another…

Q: his question is related to SQL Fundamentals, Please son't answer using your handwriting From the…

A: Given List the salesman id, rating and names of those salesmen who get rating from 3 to 5, sorted…

Q: Write an SQL query to print the first three characters of  FIRST_NAME from Worker table.    Write an…

A: According to the asked question, the solution is given below with a proper explanation.

Q: Write an SQL query to print the first three characters of FIRST_NAME from Worker table. Write an SQL…

A: We are going to write query for both 1- To print the first three characters of FIRST_NAME from…

Q: Write an SQL query to print the first three characters of FIRST_NAME from Worker table. Write an SQL…

A: Given that write an SQL query to print the first three characters of FIRST_NAME from Worker table.…

Q: Write SQL queries for the following statements (Use only Cartesian product and join)…

A: SQL is the structured query language used for relational databases. A relational database consists…

Q: Write SQL queries for the following statements (Use only Cartesian product and join)…

A: 1. Ans PNAME ((Scity= 'islamabad'(Customer)) ⋈CID (Order))

Q: Use the data in those tables and show the SQL statements to display or modify data as indicated in…

A: SELECT s.Name, s.SalaryFROM SALESPERSON  sINNER JOIN ORDER oON s.Name=o.SalespersonNameWHERE…

Q: use the following statement to Write a PL/SQL Function that accepts 4 parameters, 2 strings…

A: DECLAREStudent1 varchar2(32767);Student2 varchar2(32767);S1Marks number;S2Marks number;c…

Q: 15. Let's update the total credit for yourself to 45. Use the update statement to do that. You can…

A: 1. Before Executing Query :  UPDATE student SET tot_cred='45' WHERE ID='43123';   After Executing…

Q: Write SQL statements that will perform the following.  1. Select all the unique values from the…

A: The SELECT DISTINCT  is used to return only unique(different) values. In a table, a column may…

Q: Write an SQL query to fetch those employees who live in Toronto and work under manager with…

A: Question. Write an SQL query to fetch those employees who live in Toronto and work under manager…

Q: Use the given database to output the results of the following SQL queries: b.) SELECT ∗ FROM…

A: INTRODUCTION: A database consisting of several tables (such as COURSE, DEPARTMENT, INSTRUCTOR) are…

Q: Given the following relation: Movie (MovieID, Title, Genre, Year) Write a PL/SQL block of code that…

A: Given:  Movie (MovieID, Title, Genre, Year) Write a PL/SQL block of code that performs the following…

Q: Write the following queries in SQL, using the university schema. Find the ID and name of each…

A: DISTINCT: The “DISTINCT” keyword is used to avoid redundant data(removing duplicate values) from a…

Q: Write an SQL query for printing the details of DEPARTMENT name as "Admin". WORKER_ID FIRST_NAME…

A: Given, Table:

Q: Answer this following question using SQL Statement. From table STUDENT : Write a SQL Query to show:…

A: 1. select first_name, last_name, address from student where address='Ampang';               2.…

Q: For the following Relational Algebra / SQL statements, specify the output of each query. (do not…

A: (c)  ssno  Fname   Lname  Character 3 Clint Eastwood Bill MunnyChief Red Garnett 4 Turkan…

Q: Develop a SQL code: The resort manager wants to know the details of the guest who brought their pet…

A: Here have to determine about SQL query for given problem statement.

Q: Write SQL Query that display department id and department name that employs fewer than five…

A: Given: Write SQL Query that display department id and department name that employs fewer than five…

Q: SalesPerson (salesPersonId, salespersonLastName, dateOfBirth, gender, city, state, zipCode, salary)…

A: The above queries require knowledge of Inner Join in SQL. The INNER JOIN keyword selects records…