How can I writeSQL query of the Access of the Microsoftaboutselect, from, where,etc.?

Conditions (Rows)

1. Find all sales employees. ]

2. Find those employees who were hired in 1994.

3. Find all employees who were born in May, 1960.

4. Find all tofu products.

5. Find those products without the word 'Tiger' in their names.

6. Find those products that are priced below $10.

7. Find those products that are priced higher than $20 but lower than $30.

8. Find those products that are priced outside the range of from $20 to $30.

9. Find those products that have zero stock.

10. List all products that have to be reordered now. (Consider current stock only.)

Calculations (New Columns, Conditions)

1. List all products, sort alphabetically by name.

2. Find those products that have more than $4000 value of stock.

3. List all products by stock value, from high to low.

4. List those products that have to be re-ordered. (Consider both current stock and what is on order.)

5. If those units on order have been received as of now, what will be the increase (%) of each 1/2 product's inventory level? (Think about how to calculate "increase".)

6. Assume the company's policy states that order quantities should be no more than twice of the current stock level. List those products that violated this policy.

Summarize Data (Grouping)

1. How many salespersons does the company have?

2. Count employees by gender (use the TitleOfCourtesy column).

3. How much is the total freight the company paid?

4. Which ship (ShipName) made the most money from the company? (Do not use the MAX function! Add up freight and then sort from high to low. The first one would give you the answer.)

5. How many sales orders has Robert King brought in? (Write two queries to find out. Do NOT look at the actual tables manually.)

6. Calculate the average price (after discount) of each product.

Data from Two Tables (INNER JOIN)

1. Get a list of sales orders and responsible employees. Show last name and first name.

2. How many sales orders has Robert King brought in? (Write ONE query to find out.)

3. Write ONE query to find all of the following: Number of products under each category; Average product price of each category; and Total inventory value of each category. Show category names.

4. How much is the total inventory value of seafood? ("Seafood" is a product category.)

5. Calculate the actual average net selling price of each product. (Use simple average. Show product names)

6. Calculate the actual average net selling price of each product. (Use weighted average. Show product names)