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: Task 4: Use the IN operator to find the ID, first name, and last name of each customer for which as…

A: The above question is solved in step 2 :-

Q: What is the result of the query below:   SELECT V_CODE, COUNT (P_CODE) FROM PRODUCT HAVING V_CODE…

A: Answer: Data is filtered using the having clause in accordance with the specified requirements.…

Q: Write the T-SQL scripts for the following tasks: - Write a query to list all the Employee's details…

A: let us see the answer:- Introduction:- We are going to use a select query to list all the Employees…

Q: Create a function name BALANCE that returns the status of outstanding amount for each customer. Use…

A: Required : Function name : BALANCE It returns the status of outstanding amount for each customer. IF…

Q: 7- Write a query to produce the number of invoices and the total purchase amounts by customer, using…

A: Hey, since multiple questions posted, we will answer first question according to our policy. If you…

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: 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: Given the table customers which contains columns customer_id, first_name, last_name, and state, and…

A: SELECT C.LASTNAME, A.STATE, A.ZIP FROM CUSTOMER AS C INNER JOIN ADDRESS AS A on…

Q: SOQL Assignment Salesforce: You have to write a SOQL query in which we have to find out all the…

A: Use the Salesforce Object Query Language (SOQL) to search your organization’s Salesforce data for…

Q: Write the T-SQL scripts for the following tasks:   Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: Schema:  Employees (EmpID int, Name varchar(50), Age int, Salary float, DepartmentID int)…

A: HI THERE,I AM ADDING ANSWER BELOWPLEASE GO THROUGH ITTHANK YOU

Q: Design a query of Stores with the following: Store Name, Store Size, Sum of order amounts,  Percent…

A: JOIN Based on a common column between two or more tables, a JOIN clause is used to merge rows from…

Q: Write a SELECT statement that uses a correlated subquery to return one row per customer,…

A: SYNTAX - SELECT cust.first_name, cust.last_name, o.order_id, o.order_date, o.total_quantityFROM…

Q: Each month, a customer needs to pay whichever amount is smaller: the account balance or the minimum…

A: Each month, a customer needs to pay whichever amount is smaller: the account balance or the minimum…

Q: Write the T-SQL scripts for the following tasks: Write a query to select the count of employees…

A: SELECT     COUNT(*)FROM    employees_tableWHERE    department = "Marketing";

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: Assignment 2: Create LOV for name of the jobs and use on job column. When creating LOV pick…

A: Here is the step by step solution for the following question:   Dynamic LOV for Job NameName:…

Q: 5. Add a column to the query described in exercise 2 that uses the RANK() function to return a…

A: The above question is solved in step 2 :-

Q: Write a query that Balance of each CUSTOMER who have made purchase(s) before AND subtotal that each…

A: Sql which means structured query languages and it is a domain-specific language used in programming…

Q: Determine which orders had a higher total amount due than order 1008.

A: Explanation: The following query determines the orders where the total amount is higher than order…

Q: starting with 'S' and ending with 'H'. 7. Write a query to display the employees who joined in June.…

A: Note: as per the guideline i can solve only three questions for you.kindly repost the other…

Q: Which comparison operators are required for subqueries with many rows?

A: Subqueries that return many rows of results are known as multiple-row subqueries. IN, ALL, ANY, and…

Q: USE NORTHWIND DATABASE Write a SELECT statement using the CASE function. The statement returns two…

A: sql select statement for above question is shown in step2

Q: 7. List all customers who were referred to the bookstore by another customer. List each customer’s…

A: The answer to the question is given below:

Q: The COUNT(*) function in the SELECT clause is used to return:a. the number of records in the…

A: COUNT Function: The COUNT function is used to count the number of cells, which contain numbers, and…

Q: What is the function of a column qualifier? When do you have to use one?

A: Column qualifiers are used for distinct access of the data values in order to identify them…

Q: Create a query that that returns staff members’ names (excluding doctors), their hourly rates,…

A: Create a query that that returns staff members’ names (excluding doctors), their hourly rates,…

Q: how to write a query using a subquery to list InvoiceNumber, InvoiceDate for those products with a…

A: A Subquery or Inner query or a Nested query is a query within another SQL query and embedded within…

Q: Which group function can be used to perform a count that includes NULL values?

A: Group by functions are : SUM ( [ALL | DISTINCT ] expression ) AVG  ( ALL | DISTINCT ] expression )…

Q: 1. Write the SQL query to show all invoices (LGINVOICE) with a total (INV_TOTAL) of at least $100.…

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

Q: Write an SQL Query to list the name(s) and address(es) of employees who work at the department…

A: The solution is written in SQL. Please check the solution in the next step. Note:  As per the…

Q: Obtain the name and credit limit of the customer whose number currently is stored in I_CUSTOMER_NUM.…

A: Answer:-

Q: Write noncorrelated and correlated subqueries and know when to write each.

A: SQL (Structured Query Language) is designed primarily for managing data in a relational database…

Q: How do you indicate that a column alias should be used?

A: NOTE: - Below explanation is as per the oracle database. CONCEPT OF COLUMN ALIASING: - The column…

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: Create a function to insert a new product into an existing order, include the product id, unit…

A: SQL Query  to add a product in the list

Q: Use select statements to create queries that answer the following questions. Only provide the…

A: Two tables are provided. The name of the first table is Order. The name of the first table is…

Q: Write a query to display the checkout number, book number, and checkout date of all books checked…

A: The query follows the syntax given below.SELECT column1, column2, column3FROM table1WHERE…

Q: If the DOCTORS table has the following columns, and you want to write a SELECT statement to return…

A: If the DOCTORS table has the following columns, and you want to write a SELECT statement to return…

Q: CustomerName, ContactName, Address, City, PostalCode, Country) VALUES (‘Cardinal,”Tom B. Erich

A: Solution - In the given question, we have to identify the value of city from the given query.

Q: 7. Use the UNION operator to generate a result set consisting of three columns from the Products…

A: The UNION operator in SQL is used to combine the results of two or more SELECT queries into a single…

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: 4. Run the following Query: SELECT * FROM Books WHERE name = 'Book10'; 5. Create the "Explain plan"…

A: 4. Given SQL query: SELECT * FROM Books WHERE name = 'Books10'; We have to run this query and give…

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