Can someone help me with creating queries for the below information at the Earliest ??? Thanks in advance

Question

Can someone help me with creating queries for the below information at the Earliest ??? Thanks in advance

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Then hand it in with wrong answers, doesn't bother me.

Have you created tables to test your queries? If not, go and do so now.

Once you've created those tables, run that query that you posted. Does it run successfully? (don't guess, run it and see, I wasn't asking you to 'figure it out')

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Grumpy DBA SSChampion Points: 12515 More actions · Answer 2

djmenon21 (4/19/2016)
I cant figure out 🙁

Don't give up and expect people to help you resolve your homework dilemma, keep trying. Post your queries and the results.

Most people here are not going to give you the queries but most people will lead you in the right direction. You will learn more if you try to write these queries yourself. Write 'em, test 'em, evaluate 'em, rework 'em.

Tava SSCarpal Tunnel Points: 4122 More actions · Answer 3

djmenon21 (4/19/2016)
I cant figure out 🙁

Try to use my question 2 as a guide. Its all very similar.

Copy my temp table and modify it to meet your needs. Post the answer you think and will all help. We've all been in the same position as you before.

Question really is do you just want to pass this homework / assignment and be the end of it or do you want to move into a future database role. If it's just to pass that's fine but if you want a job these will be type of questions you can expect in interviews for a junior sql developer....

Tava SSCarpal Tunnel Points: 4122 More actions · Answer 4

Also, if you're not sure on "how to do" whats being asked (E.g. writing the code to make the tables). Try an attempt first, if its wrong we will fix it so you can continue on.

keep in mind.... If you can't write a basic query and are struggling, what is your teacher going to think when all of a sudden you have a solution for these 3 questions and they are all correct? or when you beat the smartest person in your class? I'm sure the teacher knows your skill set. Also, the answer you might get from people here is something your teacher might have never explained before or is an advanced method.

Whatever you hand in, you need to be able to confidently answer any questions if the teacher asks you to explain, because I'm sure they will ask 🙂

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 5

I see you have also posted this question here:

http://www.dbforums.com/showthread.php?1708865-Can-someone-help-me-with-creating-queries-for-the-below-information-at-the-Earliest

but on that site you have posted in the MySQL forum.....are you using MS SQL or MySQL?

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Tava SSCarpal Tunnel Points: 4122 More actions · Answer 6

J Livingston SQL (4/20/2016)
I see you have also posted this question here:
http://www.dbforums.com/showthread.php?1708865-Can-someone-help-me-with-creating-queries-for-the-below-information-at-the-Earliest
but on that site you have posted in the MySQL forum.....are you using MS SQL or MySQL?

same answers been given there, they want to see something as well.

Might as well delete this thread, if nothing will be attempted...