Display the customers company name

Assignment Help Computer Engineering

Reference no: EM132162998

USEING SQL Database Development.

Please use our cissql server, and the Northwind database

Please make sure you have the following within your query

1. The use statement with the database being used

2. Comment with your name, quiz and query number.

Query: Display the customers company name, address, city, region, employee last name, order ID and the order date for orders that meet the following criteria:

1) Use a sub-query to get the order ID, which must be within the range of 10200 and 10500.

2) The order date must be from the month of July, ( irregardless of the year).

3) The employee last name must be Peacock

Reference no: EM132162998

Questions Cloud

Require to enter the correct passcode to start application : The system uses a scramble keypad with a randomly allocated set of numbers from 0 to 9.

Example of the price floor set at zero : Discuss your own conclusion regarding what should be done about organ shortage, including references to the sources you used.

How do government finance budget deficits : 1. How do government finance budget deficits? 2. Government debts are not a problem for countries. Discuss?

What is the total number of header bytes transmitted : What is the total number of header bytes (including TCP, IP, and Ethernet headers) transmitted?

Display the customers company name : Display the customers company name, address, city, region, employee last name, order ID and the order date for orders.

Create a umlaut class diagram representing a stadium : Create a umlaut class diagram representing a stadium the stadium is characterized by having a name address city state zip code number of seats.

How does a user manage to get him or herself infected : How does a user manage to get him or herself infected with ransomware?

How round robin algorithm is actually implemented : Use Windows operating system to illustrate how Round Robin Algorithm is actually implemented.

Write a java program to manipulate grades : The user should input the numbers from the keyboard. Write a Java program to manipulate grades.

User Account

All Pages