SQL Queries: Help for a simple project

[Terrible]

I am completely new to Access. For a practice project, we've made two tables for 'Customer Data' and 'Customer Orders', full of hypothetical data. I got through that easily enough. We're then asked to create six different SQL Queries that fulfill the following requirements:

1. Find all male customers in the database. Show all the fields from the customers table for these customers.
2. Find all orders with NUMORDERLINES greater than 3. Show only the following fields from the orders table: CUSTOMERID, ORDERID, TOTALPRICE.


3. Find all orders from the year 2007. Show all fields from the orders table.
4. Find all customers whose first name is ‘JAMES’. Show all fields from the customers table.
5. Find all orders whose price is greater than $200 and that belong to clients in ‘NY’. Show FIRSTNAME, ORDERDATE, TOTALPRICE, CITY, STATE, ZIPCODE.
6. Find all orders whose price is greater than $100 and where the PAYMENTTYPE was either ‘VI’ or ‘MC’? Show FIRSTNAME, ORDERDATE, TOTALPRICE, PAYMENTTYPE.

I've attempted the first three, but the results don't seem accurate when I run them. I can show you what I have but I'm almost positive they're incorrect. I don't know how easy it would be to work with this without the database itself, but if anyone could help me get started on these I would be really grateful.

[June7]

These are all basic SELECT queries. You are using the Access query builder? Post the SQL statements of attempted queries.

Suggest not use all caps in naming convention - not as easy to read as LastName, FirstName. Also suggest no spaces in naming convention.

[Terrible]

These are all basic SELECT queries. You are using the Access query builder? Post the SQL statements of attempted queries.

Suggest not use all caps in naming convention - not as easy to read as LastName, FirstName. Also suggest no spaces in naming convention.

Thank you for responding! Sorry about the naming conventions. Those were predetermined by the project outline, so I didn't have much of a choice in them. We were told to use the 'Query Design' in Access, view it in SQL View, and then type in our formulas. I need to go to the library to send you what I have, but they are indeed SELECT queries. I'll get back to you as soon as I can.

[orange]

Further to June's request, can you show us the fields in your tables also.
Good luck with your project