Reference no: EM131399580
Assignment
Using the Northwinds "database" in MS Access, write the following queries and provide the results.
1. Write a query that returns the number of customers in the customers table.
2. Write a query that returns the number of customers in each job title.
3. Write a query that returns the job titles having greater than 5 customers.
4. Write a query that returns customer name, company, job title, phone, city and state for customers in Minnesota.
5. Write a query that returns the Orders for Customer "Company AA".
6. Write a query that returns the order numbers for customer "Company AA" and the date of the orders.
7. Write a query that returns the products ordered by "Company AA" for orders that are "Closed".
8. Write a query to return the quantity and sales total for each item on the "Company AA" open orders.
9. Write a query to return the total sales amount for each of "Company AA" open orders.
10. Write a query that returns who created and approved the purchase order for "Company AA" "Closed" orders along with the internal notes on the purchase order.
|
Discussion the working-age population movements
: Discussion the Working-age population movements. Impact of diversity trends and changes to the firm based on statistical data. Recommendation to the firm for sustaining a diverse workforce.
|
|
What is the verbal sat score
: What is the verbal SAT score such that only 16% of admitted students had a higher score?- What is the verbal SAT score such that only 2.5% of admitted students had a higher score?
|
|
Programmer designs a program
: When a programmer designs a program, there are cases where loops need to be nested. While there are no limits to the depth of nested loops, it is possible for the programmer to nest the loops too deep.
|
|
Determine approximate proportion for the given situations
: Using a computer or calculator that provides proportions falling below a specified z-score, determine the approximate proportion for each of the following situations.
|
|
Write query that returns number of customers in job title
: Write a query that returns the number of customers in each job title. Write a query that returns customer name, company, job title, phone, city and state for customers in Minnesota.
|
|
Annotated bibliography containing five sources
: For this assignment, you are to create an Annotated Bibliography containing five sources related to the three of the following objectives: 1. Analyze the roots of modern terrorism including various terrorist groups.
|
|
Is the standard deviation a resistant statistic
: Remember that a resistant statistic is a numerical summary whose value is not unduly influenced by an outlier of any magnitude. Is the standard deviation a resistant statistic?
|
|
Create a logo for the website
: Include at least four images for each destination page. Create a logo for the website. Design three navigation options for the website. Each option should include links for all the pages. You will use one of these options in the final design.
|
|
What fraction of the time would be spent at a leaf node
: What fraction of the time would be spent at nodes in the top half of the tree (nodes at levels 1 through h/2)?
|