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: 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: Using SQL Write a function called ValidSupplier(SupplierID) that takes as its only input a…

A: The ask is to write a SQL function which does the following: - take a Supplier Id as input - Check…

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: Q2: Do these queries: 1. Show department name and instructor name who is having salary greater than…

A: Due to company policies I am compelled to solve only one question and that is the first question.…

Q: Suppose a database in SQL write IF THEN ELSE Statement in PL SQL Block to check if the quantity in…

A: IF Product 2319.QuantityOnHand <= 120 THEN MESSAGE 'Stock is getting less.'; ELSEIF Product…

Q: and express in Relational Algebra each of the questions below: Grades StudentId CourseCode…

A: Q9.

Q: List the grades of students who studied the course having the code “ITDR2106” in the semester…

A:

Q: List of products names for a given list of vendor IDs:

A: As per our company guidelines, we are supposed to answer only one question per post and kindly…

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…

A:

Q: please solve sub questions iv, vii, viii only

A: delete * from Vehicle where Veh_brand like="_o%"

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

A: Answer: 98877445

Q: „By using SQL language return the

A: According to the question we need to return the items and their total number of units that have been…

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

A:

Q: Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in…

A: Ans:) In this PL/SQL block there are some errors in the syntax. The correct syntax for 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: in SQL, Create a Stored Function to identify the total number of staff assigned to each ward (the…

A: A stored function (also known as a consumer feature or user-described characteristic) is a fixed of…

Q: „By using SQL language return the items and their total number of units that have been ordered…

A: We have to pick the items where item name is not Pen and sum of Units of each Item category

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: (Consider table employees with the following colunms (EMPLOYEE ID, FIRST NAME, LAST_NAME , EMAIL…

A: Select CONCAT(M.First_Name,' ', M.Last_Name) as MANAGER_NAME , M.Department_ID from Employees E…

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: 2. Use RELATIONAL ALGEBRA to write the following queries: a) Find names and surnames of professors,…

A: In this question we have to understand about the schema provided to write a RELATIONAL ALGEBRA for…

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

A: Given:

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

A: The INSTR() function returns the position of the first occurrence of a string in another string.

Q: SELECT CONCAT(SUBSTR (first_name, 1,2), weight) FROM patients WHERE blood type= 'B' and weight > 70;

A: We are Patients table and on it a SQL query is applied whose output we are going to find out.…

Q: normalize the following Table into 3rd Normal Form.

A: Given :- In the above given question, the statements are mention below as,   Need to explain 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…

Q: АСTORS FILMS SSNO FName YearOfBirth Gender Film FilmTitle LName Number Lengthln Yearof Production…

A: a) Where year of birth greater than 1948 Lname: Wills Jovovich Costner Akar Inanir b) Film Length…

Q: Consider Following Tables. Student ( regNo, sName, sCity, sCGPA, sAge) Course ( cCode, cName,…

A: Given: Student ( regNo, sName, sCity, sCGPA, sAge) Course ( cCode, cName, credit_hours) Enrollment…