Sfrgttk

Ethernet cable only works in certain positions

Does an increasing sequence of reals converge if the difference of consecutive terms approaches zero?

Who, if anyone, was the first astronaut to return to earth in a different vessel?

Why does Python copy numpy arrays where the length of the dimensions are the same?

Can a rabbi conduct a marriage if the bride is already pregnant from the groom?

Workplace intimidation due to child's chronic health condition

Is 'bad luck' with former employees a red flag?

Should corporate security training be tailored based on a users' job role?

How to not forget my phone in the bathroom?

Why did Shae (falsely) implicate Sansa?

Is a 1hr 3min layover at ORD (Chicago) enough when coming in international?

Why do climate experts from the UN/IPCC rarely mention Grand Solar Minimum?

Identical projects by students at two different colleges: still plagiarism?

What happens when the last remaining players refuse to kill each other?

Simple Question About Conservation of Angular Momentum

Prove that a cyclic group with only one generator can have at most 2 elements

What happens if you declare more than $10,000 at the US border?

Manager has noticed coworker's excessive breaks. Should I warn him?

If an area is covered in both Ball Bearings and Caltrops, does the creature need to move at half speed or quarter speed to avoid both their effects?

Why Third 'Reich'? Why is 'reich' not translated when 'third' is? What is the English synonym of reich?

Suggestions on how to improve logo

Is it appropriate to give a culturally-traditional gift to a female coworker?

Why don't hotels offer (at least) 1 kitchen bookable by any guest?

Badly designed reimbursement form. What does that say about the company?

How do I the number of orders per employee?

How do I auto-fill data in Microsoft Access 2003?sp_ExecuteSQL, performance and table variablesImprove query performance when selecting almost all rows with many “group by” columnsWhat is the logic behind ISNUMERIC for certain special characters?SQL queries to only show most recent purchase records for individual food itemsUpdate a column for every row of a large table to a unique value in a set rangeSelect command returning different column valuesSorting a Date Column in Microsoft SQL Server Management StudioI've got 60 million sales of 800 different liquid products whose price change dailyTracking Unintended Row Changes

0

This is what I need to answer:

3. List all employees whose job title is purchasing clerk and the total number of orders each has created in the database. Show the employee id, first name, last name, and the order count in the query results. List the results in ascending order by order count.

Currently I have:

SELECT [Purchase Order].EmployeeID, Employee.EmployeeFirstName, Employee.EmployeeLastName

FROM [Employee], [Purchase Order]

WHERE [EmployeeTitle]="Purchasing Clerk";

I can't get the Count expression to return anything and my book has one page on SQL and its as basic as it could possibly be. I was barely able to write something this advanced with it.

If anyone wants to help with the last 3 I would very much appreciate it as I'm certain I won't be able to get exactly what I need.

4. What is the total dollar amount for all purchase transactions completed in January? (Hint: You can create an expression in the query design results section e.g. quantity * unitprice).




5. List all suppliers located in zipcode 33965 and 91343. List all attributes from the supplier table.




6. What is the total dollar amount for each purchase order in the database? List the PO#, PO date, and the total dollar amount in the results.

sql-server ms-access count

share|improve this question

edited 40 secs ago

jadarnel27

5,29811836

asked 1 hour ago

MewchuMewchu

1

New contributor

Mewchu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

This is what I need to answer:

3. List all employees whose job title is purchasing clerk and the total number of orders each has created in the database. Show the employee id, first name, last name, and the order count in the query results. List the results in ascending order by order count.

Currently I have:

SELECT [Purchase Order].EmployeeID, Employee.EmployeeFirstName, Employee.EmployeeLastName

FROM [Employee], [Purchase Order]

WHERE [EmployeeTitle]="Purchasing Clerk";

I can't get the Count expression to return anything and my book has one page on SQL and its as basic as it could possibly be. I was barely able to write something this advanced with it.

If anyone wants to help with the last 3 I would very much appreciate it as I'm certain I won't be able to get exactly what I need.

4. What is the total dollar amount for all purchase transactions completed in January? (Hint: You can create an expression in the query design results section e.g. quantity * unitprice).




5. List all suppliers located in zipcode 33965 and 91343. List all attributes from the supplier table.




6. What is the total dollar amount for each purchase order in the database? List the PO#, PO date, and the total dollar amount in the results.

sql-server ms-access count

share|improve this question

edited 40 secs ago

jadarnel27

5,29811836

asked 1 hour ago

MewchuMewchu

1

New contributor

Mewchu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

This is what I need to answer:

3. List all employees whose job title is purchasing clerk and the total number of orders each has created in the database. Show the employee id, first name, last name, and the order count in the query results. List the results in ascending order by order count.

Currently I have:

SELECT [Purchase Order].EmployeeID, Employee.EmployeeFirstName, Employee.EmployeeLastName

FROM [Employee], [Purchase Order]

WHERE [EmployeeTitle]="Purchasing Clerk";

I can't get the Count expression to return anything and my book has one page on SQL and its as basic as it could possibly be. I was barely able to write something this advanced with it.

If anyone wants to help with the last 3 I would very much appreciate it as I'm certain I won't be able to get exactly what I need.

4. What is the total dollar amount for all purchase transactions completed in January? (Hint: You can create an expression in the query design results section e.g. quantity * unitprice).




5. List all suppliers located in zipcode 33965 and 91343. List all attributes from the supplier table.




6. What is the total dollar amount for each purchase order in the database? List the PO#, PO date, and the total dollar amount in the results.

sql-server ms-access count

share|improve this question

edited 40 secs ago

jadarnel27

5,29811836

asked 1 hour ago

MewchuMewchu

1

New contributor

Mewchu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

SELECT [Purchase Order].EmployeeID, Employee.EmployeeFirstName, Employee.EmployeeLastName

FROM [Employee], [Purchase Order]

WHERE [EmployeeTitle]="Purchasing Clerk";

share|improve this question

edited 40 secs ago

jadarnel27

5,29811836

asked 1 hour ago

MewchuMewchu

1

New contributor

Mewchu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 40 secs ago

jadarnel27

5,29811836

asked 1 hour ago

MewchuMewchu

1

New contributor

Mewchu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 40 secs ago

jadarnel27

5,29811836

edited 40 secs ago

jadarnel27

5,29811836

asked 1 hour ago

MewchuMewchu

1

New contributor

Mewchu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 hour ago

MewchuMewchu

1