How many work centers does pine valley have

Assignment Help Computer Engineering

Reference no: EM133325796

Problem: Use the Pine Valley database to answer the following questions:

a. How many work centers does Pine Valley have?

b. Where are they located?

List the employees whose last names begin with an L.
Which employees were hired during 2005?
List the customers who live in California or Washington. Order them by zip code, from high to low.
List the number of customers living at each state that is included in the Customer_T table.
List all raw materials that are made of cherry and that have dimensions (thickness and width) of 12 by 12.
List the MaterialID, MaterialName, Material, MaterialStandardPrice, and Thickness for all raw mate- rials made of cherry, pine, or walnut. Order the listing by Material, StandardPrice, and Thickness.
Display the product line ID and the average standard price for all products in each product line.
For every product that has been ordered, display the product ID and the total quantity ordered (label this result TotalOrdered). List the most popular product first and the least popular last.
For each customer, list the CustomerID and total number of orders placed.
For each salesperson, display a list of CustomerIDs.
Display the product ID and the number of orders placed for each product. Show the results in decreasing order by the number of times the product has been ordered and
label this result column NumOrders.

Reference no: EM133325796

Questions Cloud

Describe a challenging project, how did you handle it : Describe a challenging project, how did you handle it? Why did you decide to pursue a data science degree? What do you think data scientists do

What are different addressing methods that mips isa provide : What are the different addressing methods that the MIPS ISA provide? What does Amdahl's law say? Why is it important?

Identify a stakeholder that may be impacted : Identify and explain key artifacts and activities within the defect management process. For each artifact and activity, identify a stakeholder

Create an add item html page that will add items to database : Create an add Item HTML page that will add Items to the database. After adding Items your program should return to the add Item page.

How many work centers does pine valley have : How many work centers does Pine Valley have?Where are they located? List the employees whose last names begin with an L. Which employees were hired during 2005

Describe other ways that people have changed their behaviour : Basically we have adapted to the app rather than the app adapting to the usual business convention. Describe five other ways that people have changed

What steps would you take to prevent an sql injection attack : What steps would you take to prevent an SQL injection attack? What are advantages and disadvantages of dynamic SQL statements? What types of databases are

How is technology used in planning student learning goals : How is technology used in planning and achieving student learning goals? How is technology used in transforming the classroom into a global learning center?

Identify preventive activities and detective activities : Identify preventive activities and detective activities that may have been missed or that operated ineffectively, allowing the fraud to occur

User Account

All Pages