Edit: Would the answer look like this
Michael, thank you for making an attempt a solution this time (I added your comment to the original question so it could be formatted for easier reading). You are on the right track, but you need to tweak a few things.
First, when you are joining multiple tables that have a column in the same name, you need to disambiguate for the server. This can be done by prefacing the column name with either the table name or table alias. If you do not know what a table alias is yet, just use the table name, aliases will come later.
Next, when you are using a string literal, you need to enclose it in single quotes. Such as 'Internet Advertising'
Then, you cannot separate criteria in your where clause with commas, they have to be separate by 'and's. In your attempt you seem to go back and forth and use both.
The big problem of course is that I think you are answering the wrong question. You are specifying the skills it should be returning. If I understand the question right, that should be the results you get not the criteria you use.
If you want to try again and post another attempt here, I think many of us would be happy to comment on it. If including a code sample, please either post it as an answer or edit your original question. You cannot format code samples in a comment. Also, please remember to format the code samples. It is so much easier to read that way.
answered Mar 26, 2010 at 04:49 PM
Brief Explanation: Above I use three queries; One main select query and two sub queries(or nested queries)
Also you can solve these problem easily using JOINs.
I dont know if i helped or confused you here but you should be able to get the idea and research a little bit and you soon be able to solve the problem. Once again try a little bit harder to solve your homework by yourself before you post here.
You have provided nothing more than a query. You need to provide some detail and what your actual question is.
answered Mar 26, 2010 at 02:56 PM
Is this April the fool? Michael, I am starting to feel you are purposely trying to annoy the community!
answered Mar 26, 2010 at 03:00 PM