Using nwind database, create a query to show company name, product name, and quantity for items ordered where the quantity is greater that the average quantity for that customer. If the average of a customer is 15, than items ordered by that customer with a quantity more than 15 should be shown in the results. Note quantity field is in order_details table. You must use a corelated subquery for this problem. sql workbench

Q: 1. Table : ASSIGNMENT D ASSIGNMENT N NMAON DATE MM EMP MUN AiNO AlON CHO AONHOURI NON CHA 35 42 t00…

A: Explanation In SQL, the SELECT query is used to fetch or retrieve the data from the database table.…

Q: Display in product ID order the product ID and total amount ordered of that product by the customer…

A: SQL queryDerived table:Derived table is a table that is used to create a temporary table that is…

Q: Create the following SQL Server queries that access the Northwind database. Place them in txt file…

A: This question comes from MySQL which is a topic in computer science. In this question we are going…

Q: Please write a query for dvdrental database. Please list all the customers. For each customer…

A: According to the information given: We have to write a query for dvdrental database on the basis of…

Q: Without re-creating the table write one sql statement to answer this question. Change the definition…

A: Actually, database is a used to store the data and we can change ,manipulate and access the data.

Q: CUSTOMER aus CODE CUS LNAME CUS FNAME CuS INITIAL CUS AREACODE CuS PHONE CUS BALANCE PRODUCT P cODE…

A: SQL (Structured Query Language) is a database query language. According to ANSI, it is the…

Q: List the LastName, FirstName, and the total number of orders placed by each customer (as OrderCount)…

A: SQL is a structured query language, that's designed to facilitate the extraction the specific…

Q: Write a SQL query that selects OrderID and OrderDate from the Orders table and OrderDetailID from…

A: Introduction: A JOIN clause is used to merge data from more than "2" tables based on a standard…

Q: Using the information in the ASSIGNMENT table, write SQL code that will return the total number of…

A: Introduction: SQL syntaxThe SQL code for connecting the tables "Employee" and "Assignment" to get…

Q: Every guide receives their first review 6 months after their hire date. List the guide’s last name,…

A: SQL query to display all the list of the guide’s last name, first name, hire date, and his/her first…

Q: Write the SQL code that counts the number of assignments ordered for each project. Call this…

A: We have four tables namely: JOB PROJECT EMPLOYEE ASSIGNMENT We wish to write a query that counts…

Q: Using the EMPLOYEE, JOB, and PROJECT tables in the Ch07_ConstructCo database, write the SQL code…

A: Using the EMPLOYEE, JOB, and PROJECT tables in the Ch07_ConstructCo database, write the SQL code…

Q: Find the service ID and property ID for each service request whose estimated hours is greater than…

A: Hello student Greetings Hope you are doing great. Thank You!!!

Q: Write the SQL queries for the following questions and show results. List all the section numbers of…

A: In the structured query language, the query consists of the three clauses that are used to retrieve…

Q: In SQL, Using the DUAL table, create a query that will return the current day of the week, hour,…

A: SELECT convert(varchar(10), GETDATE(), 108) 'time', DATENAME(weekday,GETDATE()) 'day of the week'…

Q: Write a query to display the first name, last name, and email address of employees hired from May 1,…

A: Here we have to write 2 queries whose details are as follows:Write a query to display the first…

Q: Create a PL/SQL query to display the customer name, employee name and the coin product returned. In…

A: Create table ReturnDetails(CustomerName varchar(30),EmployeeName varchar(30),CoinReturn…

Q: Select clause and from clause: Display the columns specified above in the problem  statement from…

A: Write a query to display the author ID, first name, last name, and year of birth for all authors…

Q: Write an SQL query to display: The last name of the student who registered at the last. Your output…

A: Write SQL query to display the last name of the student who registered at the last. Given: The…

Q: Q3: How many unique titles do we have in the employee table? Hint: You need to create TWO queries,…

A: 1)   SELECT DISTINCT titles FROM EMPLOYEE

Q: Animal animal_id name adopter_id Adopter adopter_id name Given the above data for an adoption…

A: Cross join : Each row from the first table is combined with each row from the second table using a…

Q: Using Northwind: USE MICROSOFT SQL SERVER Create a query selecting the Manager first name, last…

A: For writing the given Sql query we will use the join clause.

Q: Answer the query using SQL. For each department that controls more than 3 projects, retrieve the…

A: Introduction of DBMS: A database is a collection of data that are used to produce useful information…

Q: Using the university schema, use SQL to do the following: For each student who has retaken a course…

A: SQL is also known as structured query language.

Q: For each band that currently has a female member: Return the name of the band and each artist's…

A: The question has asked us to join three tables, namely, p_artist, p_band, and p_member, based upon…

Q: Write a query to display all vendors sorted by vendor name.   Write a query to display the product…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: The Binder Prime Company wants to recognize the employee who sold the most of its products during a…

A: Actually, given information: The Binder Prime Company wants to recognize the employee who sold the…

Q: Using the EMPLOYEE, JOB, and PROJECT tables in the Ch07_ConstructCo database,write the SQL code that…

A: GIVEN: Using the EMPLOYEE, JOB, and PROJECT tables in the Ch07_ConstructCo database,write the SQL…

Q: Use SQL commands. Include both SQL commands and results in your answers. Include screenshots of the…

A: Join: A JOIN clause is used to combine rows from two or more tables, based on a related column…

Q: salary is above 4000 and job_id starts with a letter “S”

A: 1. SELECT * FROM employee WHERE (salary > 4000) AND job_id LIKE 'S%'   2. SELECT              *,…

Q: please assist with the following questions. need to write a syntax in SQL server. Create an UPDATE…

A: It is defined as SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to…

Q: Write the SQL 2.  Using these aliases CUSTOMER C PURCHASE P Find the last name, and location of…

A: Using these aliases CUSTOMER C PURCHASE P Find the last name, and location of each customer. Order…

Q: List the balance characteristics of the customers who have made purchases during the current invoice…

A: SELECT  CUS_CODE, CUS_BALANCE FROM  CUSTOMER WHERE  CUSTOMER.CUS_CODE IN     (SELECT DISTINCT…

Q: Write sql code for Use derived tables and joins to create a list of players who have scored more…

A: Fielding Table is not given but it is mentioned to consider same as other table. So, we can join all…

Q: Display the name of customer 16 and the names of all the customers that are in the same zip code as…

A: Here have to determine about sql query for given scenario.

Q: Write a SQL query that selects OrderID and OrderDate from the Orders table and OrderDetaillD from…

A: Introduction: Structured Query Language (SQL) is an acronym for Structured Query Language. SQL is a…

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.