SQL Help Please

Question

SQL Help Please

jsalzm1

Valued Member

Points: 67
More actions
April 17, 2016 at 7:32 pm

#318124

Guys, Im new to sql and I have had trouble writing these codes. I dont have anything to check my answers too so I can study. If anyone could please help, that'd be great.
I have screenshots attached. Thank you

Viewing 7 posts - 1 through 6 (of 6 total)

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

we can't help you with homework, but if you have specific questions you can't seem to get right, if you show us what you've done,we can offer suggestions.

If i do the homework, i want the grade or job myself, no sense in involving a middleman, right?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 2

I'm with Lowell. I'm only writing the query if I get the grade.

If you're stuck, try writing the query. Show us what you have tried that doesn't work. I'm sure any of us would be happy to help you fix a query. I just don't see why I should do the work for you.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Luis Cazares SSC Guru Points: 183706 More actions · Answer 3

Were you really so lazy that you couldn't even copy the problem? That won't get you anywhere.

If you don't have anything to test your answers, then build something. Download SQL Server (Express and Developer editions are free) and create your database and tables, then insert data into them. SSMS has a decent GUI to help you create everything.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

jsalzm1 Valued Member Points: 67 More actions · Answer 4

Thanks guys, I and a few classmates figured it out.

Luis, you don't need to be so rude. I actually have a great job lined up and I am getting both a minor and a bs in engineering, so I am not lazy. I've busted my ***. I attached the problems below because of the ERD. But thank you for the reply

Have a great rest of your Monday everyone

Luis Cazares SSC Guru Points: 183706 More actions · Answer 5

jsalzm1 (4/18/2016)
Thanks guys, I and a few classmates figured it out.
Luis, you don't need to be so rude. I actually have a great job lined up and I am getting both a minor and a bs in engineering, so I am not lazy. I've busted my ***. I attached the problems below because of the ERD. But thank you for the reply
Have a great rest of your Monday everyone

I'm sorry, it's some kind of tough love, partly generated by Monday morning.

I gave you a good advice, and you can ask anyone. If you're not able to test your solutions, your can't say you have a solution. I told you a way to test.

I'm sorry if you feel offended and believe that having a BS in Engineering is not being lazy. There are lots of people that completed their BS and stopped learning. They're lazy and complain about not having a good job or getting promotions. So, please prove that you can do things right every single time. Not to us, but to you.

Have a nice week.

P.S. I don't want to be rude, just realistic.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Y.B. SSChampion Points: 11649 More actions · Answer 6

jsalzm1 (4/18/2016)
Thanks guys, I and a few classmates figured it out.
Luis, you don't need to be so rude. I actually have a great job lined up and I am getting both a minor and a bs in engineering, so I am not lazy. I've busted my ***. I attached the problems below because of the ERD. But thank you for the reply
Have a great rest of your Monday everyone

Luis is a very helpful contributor to these forums I can assure you. This is one of the best communities online for SQL. You just have to understand that we subscribe to the thought that we want to help people succeed.

Cheers and welcome to the forums! 🙂

SELECT quote FROM brain WHERE original = 1
0 rows returned