x

What are the zip codes of consultants who finished their projects in the 2nd half of Dec. 2008

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

PROJECT_CONSULTANTS

P_ID C_ID ROLL_ON_DATE ROLL_OFF_DATE TOTAL_HOURS 1 101 06/15/2008 12/15/2008 175 1 104 01/05/2008 12/15/2008 245 1 103 01/05/2008 06/05/2008 50 1 105 01/05/2008 12/15/2008 45 2 105 07/17/2008 09/17/2008 25 2 100 07/17/2008 09/17/2002 0 3 103 09/15/2008 03/15/2009 125 3 104 10/15/2008 12/15/2008 50 4 105 06/05/2008 06/05/2009 25 4 104 06/15/2008 12/15/2008 125 4 102 07/15/2008 12/15/2008 30 5 105 09/19/2008 03/19/2009 15 5 103 09/19/2008 03/19/2009 15 6 103 09/19/2008 03/19/2009 5 6 104 09/19/2008 03/19/2009 10 7 102 05/20/2008 12/20/2008 125 7 100 05/25/2008 12/20/2008 100 
more ▼

asked Mar 26, 2010 at 02:04 PM in Default

Michael 4 gravatar image

Michael 4
9 9 9 9

Michael, could you at least accept some of the answers on your other questions - if you participate in this site, you are more likely to be helped. At the moment you just seem to be flooding us with badly formatted homework questions. Also please try and format your questions with the code format button.
Mar 26, 2010 at 02:13 PM Kev Riley ♦♦
Eventually people will stop helping you. Your questions will be closed, and possibly even your account will be deleted. If you show that you have learned, and that you want to participate here, then we will all show you respect.
Mar 26, 2010 at 02:21 PM Kev Riley ♦♦
Are these all homework questions? If so, I'd recommend no one help until a little bit of self-work is shown. Have you attempted to write this query and it didn't work? Let's see what you have.
Mar 26, 2010 at 02:27 PM Grant Fritchey ♦♦
The help that I will provide is formatting all your questions - as I have done your previous examples. There are several people here who would be welcome to stay in my house should they wish, and it irks me that they have to hurt their eyes looking at unformatted drek.
Mar 26, 2010 at 04:13 PM Matt Whitfield ♦♦
Would the Answer look like this Select C_Zip, Roll_Off_Date from Consultant, Project_Consultant where C_zip=Roll_off_date And C_zip=32825,32811,32822,32800,32816
Mar 26, 2010 at 08:23 PM Michael 4
(comments are locked)
10|1200 characters needed characters left

1 answer: sort oldest

You have provided nothing more than a query. You need to provide some detail and what your actual question is.

If you really need all this help with homework, it would be advisable to get a tutor.

more ▼

answered Mar 26, 2010 at 02:55 PM

CirqueDeSQLeil gravatar image

CirqueDeSQLeil
4.8k 10 11 15

(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:

x374
x76

asked: Mar 26, 2010 at 02:04 PM

Seen: 1080 times

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