question

Michael 4 avatar image
Michael 4 asked

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
queryhomework
5 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
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.
5 Likes 5 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
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.
4 Likes 4 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
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.
3 Likes 3 ·
Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
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.
0 Likes 0 ·
Michael 4 avatar image Michael 4 commented ·
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
0 Likes 0 ·

1 Answer

·
CirqueDeSQLeil avatar image
CirqueDeSQLeil answered

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.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.