Show the customers company name and address

Assignment Help Computer Engineering

Reference no: EM132174973

USING SQL Database Development

This question is worth 25 points.

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) The order ID must be within the range of 10200 and 10500

2) The order date must be from the month of July

3) The employee last name must be Peacock

Reference no: EM132174973

Questions Cloud

Develop a strategy for operating system and application : Conduct a comprehensive and detailed analysis of techniques for hardening operating systems and applications.

Scientific name for both a monocot and dicot : What is the common and scientific name for both a monocot and dicot?

Transition of rna to dna and proteins : Name one feature that the transition of RNA to DNA and proteins, and the transition of prokaryotic to eukaryotic unicellular organisms

What pre?x before saccharide would you use to describe : Each of the reactants in reaction A is a single sugar molecule, also called a monosaccharide. What pre?x before saccharide would you use to describe sucrose?

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

List the citric acid cycle intermediates : 1) Which amino acid involved in nitrogen removal is regulated... and why is this step ideal?

Design a data management software on c : Using Structures, Unions, Files and Dynamic Memory allocation and all semester's topics design a Data Management Software on C.

Why have musk deep populations dropped dramatically : Why have musk deep populations dropped dramatically? What has been done to help protect them? What else might you suggest be done.

What gas was collected in the test tubes during incubation : It is about biology lab. Fermentation in Yeast with different substrates. What gas was collected in the test tubes during incubation?

User Account

All Pages