Help with homework

[wilsontng]

I got these two SQL questions that I need help, thanks guys !

1) SELECT Books.Title, Books.PublDate, Publishers.PubName
FROM Publishers INNER JOIN Books ON Publishers.PubID = Books.PubID


WHERE (((Publishers.PubName)="Little, Brown and Company"));

1. Display ISBN and PublDate of all the books published by publishers
2. Display Title and AuthorCode of all the books published by Little,Brown and Company
3. Display Price and PublDate of all the books published by Pearson
4. Display Title, PublDate, and PubName of all the books published by Little,Brown and Company
I think it's 4

2) SELECT Books.Title, Books.PublDate
FROM Author INNER JOIN Books ON Author.[Author ID] = Books.AuthorCode
WHERE (((Author.FirstName)="Anne"));

1. Display Title, PublDate of books written by Rice
2. Display Title, PublDate of books written by Anne
3. Display ISBN, PublDate of books written by Anne
4. Display PubName, PublDate of books written by Anne

[June7]

What is it you find confusing about the questions. They seem quite simple and straightforward to me.

I agree with your first. You don't indicate a choice for the second.

[orange]

What exactly have you tried? Can you show readers the code or logic or query or??? that you are having difficulty with?

We don't do homework questions as such. We try our best to help users who have given an honest try and are having some difficulty. Such difficulty can include things like concepts, design/structure, Access functions and syntax, SQL among others.

Good luck with your project/assignment.

[wilsontng]

These are from the mock test and to be honest, I do not have sufficient knowledge to solve these questions. Can you guys please help me

[June7]

Mock test for what? These are very basic query statements. Again, exactly what do you not understand about them? What do you think the key words SELECT and WHERE mean? Those alone should be enough to clue you as to the correct answer choice. Perhaps you can benefit from some tutorial sites:
http://www.w3schools.com/SQl/default.asp
http://www.rogersaccesslibrary.com/

[wilsontng]

I know what SELECT means but other terms such as WHERE, INNER JOIN, etc confuse me that they might alter the results

[orange]

@wilsontng

Where is the sample of your effort/attempt?
June has given you excellent reference links.

Don't overlook the power of Google to find/research.

Here is a link to Introductory SQL videos on youtube.
https://www.google.com/search?q=yout...utf-8&oe=utf-8

Tell us more about the course to which this homework is associated.

Good luck --but you have to do some work and show readers what you are doing/trying/not understanding.

[June7]

As I said, info in the SELECT and WHERE clauses are enough to determine the correct response. I already affirmed your first answer. What would you think is the answer for the second question, and why?

[wilsontng]

The course is information system which covers the basics of Excel, Words, PPT and Access. Obviously, I didnt paid attention in class but I'm trying to catch up. Of course Ive googled about the stuffs Im asking. I guess what is making me confuse is this: I know that the SELECT statement determines the titles that will appear in the result, but will it be altered by other clauses ? and what is the role of () []

For example:
SELECT Author.[AuthorID], Count(BookISBN) AS CountofISBN
FROM Author INNER JOIN Books ON Author.[Author ID] = Books.AuthorCode
GROUP BY Author.[AuthorID];

From what Ive scavenged on the internet, im guessing that AuthorID and CountofISBN will appear in the results

and what does this part do ? ON Author.[Author ID] = Books.AuthorCode

[June7]

The [] define object and field names. This does allow the use of spaces and special characters/punctuation, although neither is recommended with exception of underscore. The () define order of operations. Access will automatically try to supply both in the query builder, even when not needed. None of the () in the first two examples are necessary.

The ON clause defines the fields for establishing a link between related tables.

The () in the last example are part of a function declaration.

The SELECT statement determines what fields will be retrieved. The other clauses can determine what data will be retrieved for each field.