a. Write a query to find the salesperson and customers who belongs to same city. b. Write a query to find the name and the Amount purchased by the customers who's ordered amount exists between 3500 to 5000. c. Write a query to find all the orders issued by the salesman "JJJ".

Q: a) Write the standard SQL query to retrieve all information about the customer whose customer number…

A: Here is the Answer and Explanation

Q: Write a query to print all employees name, job title, salary and department name. ii. Write a query…

A: i. select e.ename, e.job, e.sal, d.dname from emp e, dept d where d.deptno=e.deptno; ii. select…

Q: Now write a query which make use of equijoin to display the output as follows: Output Amani CS306…

A: I have provided a solution in step2.

Q: Write inner join SQL query that find those employees who deals with customers of their cities.…

A:

Q: Write a query

A: SELECT statement The SELECT statement lists the table contents. It is a clause used in the database…

Q: 1) Write a query to print all clerks and salesmen names and salaries along with their departments…

A: Q: Write a query to print all clerks and salesmen names and salaries along with their departments…

Q: 3. Run a query that gives the average grade on the final exam for male students and for female…

A: Since we need two groups of data i.e male and female, we must use group by clause and perform…

Q: Write a SQL query to fetch the different projects available from the EmployeeSalary table. Write a…

A: Question 1. Write a SQL query to fetch the different projects available from the EmployeeSalary…

Q: Write a SQL query to fetch the different projects available from the EmployeeSalary table. Write a…

A: According to the question: Question 1. Write a SQL query to fetch the different projects available…

Q: Find the Output of the following query SELECT TO_DATE(June 19, 1990','fxMonth dd, YYYY')AS "Date“…

A: SELECT TO_DATE('June 19, 1990','fxMonth dd, YYYY') AS "Date"FROM DUAL; o/p 19-June-1990

Q: a). Write a query to get the list of employees who joined during the years 1990 and 1991.

A: TO_CHAR Function : TO_CHAR function is used to typecast a numeric or date input to character type…

Q: Find the output of the following query. SELECT LENGTH(REPLACE ('FINALEXAM FINALEXAM, F;"TAN')) FROM…

A: Answer : the Given SQL Output is 23 : Because string will replace 'F' to 'TAN' so, the final string…

Q: 1. Write an SQL query to find the CUSTOMERNAME who order the COMPUTERS. 2. Write an SQL query to…

A: It is defined as a Structured Query Language, is a programming language designed to manage data…

Q: Q1: Write a query to find the students working in a company   having more ratings than their seniors

A: select student_name from EMPLOYEES RATING TABLE where designation != senior and rating >= 9

Q: 6. Write an SQL query to display the ID, ITEMNAME, CUSTOMERNAME and price is not equal 35000 and…

A: As per Bartleby's guidelines “Since you have posted a question with multiple sub-parts, we will…

Q: First of all whole question is given I just need out of given queries ASAP!!       Write the SQL…

A: create table User (User_id integer PRIMARY KEY, Name varchar(100), City varchar(100), Order_date…

Q: Write a query that produces the following for each employee: earns monthly but wants . Label the…

A: a query that produces the following for each employee: <employee last name> earns…

Q: 3. Write a query that retrieves the following results (note the column names and order of results):

A: The required result needs to fetch below columns :   Pub_id -> from publisher table Publisher's…

Q: Problem 9 Write a query to count the number of invoices.

A: SQL is a language to operate databases in searching and filtering the data according to the query

Q: Write an SQL query using the IN operator to show all customers residingin the following zip codes:…

A: As the database is not given we have assumed the database CUSTOMERS. SQL query to create table…

Q: Write an SQL query to display Product ID, name and product date for the products that have been…

A: According to the question below the Complete Query:

Q: 4. Write a query to count the number of invoices.

A: 1. a)CREATE TABLE CUSTOMER (    CUST_NUM int,    CUST_LNAME varchar(30),    CUST_FNAME varchar(30),…

Q: 6- Create a query to produce the total purchase per invoice, generating the results shown below,…

A: Actually, SQL is a language to operate databases in searching and filtering the data according to…

Q: Which of the following does NOT belong to the SQL Number Functions?

A: 1) function MOD belongs to SQL number functions, it returns the remainder of n divided by m, example…

Q: Q1 Write a program in PL/SQL to print a list of names employees and the names of the departments to…

A: Textual PL/SQL Code :- -- create a table --CREATE TABLE Employees (  id INTEGER PRIMARY KEY,  Name…

Q: Write a query to display the employee number, first name, last name, and largest salary amount for…

A: Actually, database is a used to stores the data.

Q: Write the SQL statements for the following User table. User_id   Name City   Order_date…

A: --query to create user tablecreate table user(User_id int primary key,Name varchar(50),City…

Q: Write an SQL query to fetch “FIRST_NAME” from Worker table using the alias name as . ii.Write an SQL…

A: An SQL query to fetch “FIRST_NAME” from Worker table using the alias name as <WORKER_NAME>…

Q: Write an SQL query to fetch “FIRST_NAME” from Worker table using the alias name as . ii.Write an…

A: 1. Query: SELECT FIRST_NAME AS WORKER_NAME FROM WORKER

Q: Write an SQL query to fetch “FIRST_NAME” from Worker table using the alias name as . ii.Write an SQL…

A: Since you have not provided the db schema containing the table and column details, I am providing…

Q: .Write an SQL query to fetch “FIRST_NAME” from Worker table using the alias name as .    ii.Write an…

A: Syntax: SELECT column_name AS alias_nameFROM table_nameWHERE [condition]; Query:   i) SELECT…

Q: Run a query that reports back the average of each exam in the same query.

A: The following query will return the average of each exam- exam1, exam2 and exam3 in the same query:…

Q: Write an SQL query using the AND operator that show all orders shoppedon April 1, 2009 shipped to…

A: SQL query: SELECT * FROM Orders WHERE order_date = ‘April 1, 2009’ AND state = ‘Florida’;

Q: Write the SQL query to display the cid of all employees.  Write the SQL code to list all…

A: According to company rules we are only supposed to answer 3 subparts kindly upload the other…

Q: Query 3: Write a parameter query to display the names of all prospects each member tried to recruit…

A: Here have to determine query for given problem.

Q: Write a query to count the number of invoices  In the SQL Query do the following  In this query,…

A: count function in SQL is used to count the record, raw, columns in the table. syntax to count a…

Q: Find the output of the following query: SELECT INITCAP (COURSE NAME) FROM STUDENT WHERE…

A: Answer : -   option A) Math For It, Maths For It

Q: T mertemp Write a query to display the guest names who are from Ooty. For instance, the guest name…

A: Note - No database query language is mentioned so the above question is solved using Oracle.   Query…

Q: 8- Write a query to generate the total number of invoices, the invoice total for all of the…

A: Objective: A query should be written to display the total number of invoices, the invoice total for…

Q: Write Queries for the following: a. List all student whose Surname begins with b or end with a or…

A: Question 3 is answered as per the guidelines, please repost other questions. The data inserted into…

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: Based on the stage 2, write queries for the following questions: Sample output are provided for some…

A: As per our guidelines we are supposed to answer only one question. Kindly repost other questions as…

Q: Write in SQL a command that creates the table Supplier according to the above description . Write in…

A: 1. The create table command would work as follows:  CREATE TABLE Supplier (    SupplierID int NOT…

Q: Study the given EMPLOYEES table, From the employees table: EMP_ID SALARY 10 300 20 600 30 700…

A: Here we use MAX() function by passing salary as argument this will return salary with maximum value…

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: Using the Employees table, write a subquery that will display First_Name, Salary and Department_id…

A: The programmer need to use “SELECT” and “IN” method to display output. A query to display…

Q: Write a query to display the guest names who are from Ooty. For instance, the guest name "geeta…

A: Here we need to get the names whose address is Ooty. After looking at the ER diagram it is clear…

Q: a. Find all movies with a cost less than or equal to the average movies cost b. Write a query to…

A: Below is the correct code for the SQL query to enter the values of DATE in respective tables. Kindly…

Q: Guest details and Total Charges paid Develop a simple SQL query Display guest details who paid total…

A: According to the given table schema and problem statement out task is to develop a SQL query a to…

Q: Employees(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_D…

A: SELECT * FROM employees WHERE salary > ALL(SELECT avg(salary)FROM employees GROUP BY…