SOLVE SQL

Looks like you're near Columbus, Ohio, USA — switch to Columbus / Central Ohio to see local posts first?

Archived from the original Sajha.com — preserved as posted, replies can no longer be added here.

Archived Post

NOW I need to MODIFY THIS with FOLLOWING QUESTION Any ideas on how I can modify existing code?

cp21 · Nov 18, 2015 11:50 AM · 16,154 views

5 Replies

Insert into Sajha Values('Homework','Due soon','Lazy ass') Where Cp21.Effort is null

T-mobile · Nov 18, 2015 11:59 AM

Are you going to post all the questions in your homework or have you put any effort from your side to solve it?

virusno1 · Nov 18, 2015 11:59 AM

just add Where itemprice > 400.

SolveSQL · Nov 18, 2015 12:16 PM

thanks solvsql, i have tried that but unexpected results show up, dont think its accurate

cp21 · Nov 18, 2015 12:19 PM

i got it... thanks all had to remove sum of orderitems and left count as is. desired results are displayed after running query thanx

cp21 · Nov 18, 2015 12:23 PM

This conversation is preserved exactly as it was on the original Sajha.com and can't accept new replies.