Air Compressor Bot
|
|
Home |
How it works |
Projects archive |
Contact Us Air Compressor Bot |
|
| The Career Path of Freelance Programming Jobs |
Sql Queries |
 |
Bidding Time: |
25/06/2007 23:52 - 02/07/2007 23:52 |
Budget: |
Maximum $40 |
Status: |
Closed |
|
|
|
Job Type: |
|
Description: |
Department(DeptNum, Descrip, Instname, DeptName, State, Postcode) Academic(AcNum, DeptNum, FamName, GiveName, Initials, Title) Paper(PaNum, Title) Author(*PaNum, *AcNum) Field(FieldNum, ID, Title) Interest(*FieldNum, *AcNum, Descrip) I need simple SQL queries to look for the following: How many distinct authors of papers are there? (That is, if an academic has written more than one paper, he (she) is one distinct author.) Are there any departments whose names are null? If so, display all their details. Do any institutions have a department where no academics have written a paper? If so, return the name of the institution and the department number. Are there any departments that do not employ any academics? If so, show full details of those departments. List the paper numbers of papers that have been co-authored by 3 people. Are there any academics with the same family name that have provided the same description for their field of interest? If so, return their given name, family name and the description of their field of interest. Which academics have published a paper with at least one academic from Tasmania? Return their academic number, given name, family name, and department number. (Use LIKE '%Tas%' to build the query in stages.) I need this done in 7 days. As you can see, it's very simple queries. Related Projects:  Web form- cascading drop downs in a repeating section (pref. AJAX) Site Editing In Javascript Zencart Design, & Integration Simple Java App For Cellphones VBulletin Programmer - Hacks - modulesThis project is the proprietary information of .
Click here to remove this project from OUR database.
|
Operating System: |
N/A |
Database System: |
N/A |
| <<< back |
|
| Home | Projects archive | RSS | Resources | Links | Contact Us | © 2004-2008 ProjectsList.biz /0.419 |