x

What are the names of the consultants who got score of less than 90 in their evaluation

CONSULTANT

C_ID    C_LAST  C_FIRST C_MI    C_ADD   C_CITY  C_STATE C_ZIP   C_PHONE C_EMAIL
100 Myers   Mark    F   10 Sky Blvd.    Orlando FL  32825   4075551212  mm@xx.com
101 Hernandez   Sheila  R   33 Left Cr. Orlando FL  32811   4071115555  sh@yyx.com
102 ZHANG   Brian       89 SE Ave.  Tampa   FL  32822   3211515555  bz@mm.org
103 Carlson Sarah   J   22 NW Pl.   Orlando FL  32825   4075111111  sc@uu.gov
104 Courtland   Paul    R   91 Water St.    Orlando FL  32800   4075151155  pc@pp.net
105 Park    Janet   S   15 High Rd. Miami   FL  32816   9541115555  jp@hr.net

EVALUATION

E_ID E_DATE P_ID EVALUATEE_ID EVALUATOR_ID SCORE COMMENTS 100 01/07/2009 1 101 105 90
101 01/07/2009 1 104 105 85
102 01/08/2009 1 103 105 90
103 12/20/2008 1 105 103 100
104 12/29/2008 1 105 104 75
105 01/15/2009 1 105 101 90
more ▼

asked Mar 26, 2010 at 11:15 AM in Default

Michael 4 gravatar image

Michael 4
9 9 9 9

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Try Something like this:

Select C_Last, C_first from Consultant
Where consultant.C_id = Evaluation.EVALUATEE_ID
and Evaluation.Score < 90

Also please show some effort and you better check out this link it might get u upto speed www.w3schools.com

Good Luck!

BTW Please format your question.

more ▼

answered Mar 26, 2010 at 01:02 PM

DaniSQL gravatar image

DaniSQL
4.9k 33 35 39

@Dani - i removed the reformat of the question from here - hope you don't mind!
Mar 26, 2010 at 04:15 PM Matt Whitfield ♦♦
Not at all. I wasnt able to edit the question and I put it here hoping someone will copy and paste it to the original question.
Mar 26, 2010 at 05:22 PM DaniSQL
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x371
x75

asked: Mar 26, 2010 at 11:15 AM

Seen: 1270 times

Last Updated: Mar 26, 2010 at 04:14 PM