Click here to Skip to main content
15,040,494 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,
I am a deaf student. I would like to ask you need the answer to my questions. I am very sorry for that I couldn't know how to solve about show column and calculate between two dates. Here a list:

1. What writes a query to show which tasks have not been allocated to anyone. Show all columns.
2. What writes a query to show which tasks in the task table have not been completed. Show all columns.
3. What writes a query to show which tasks in the task table have been allocated but not completed. Show all columns.
4. What writes a query to show the Emp Full Name, DateJoined, DateLeft and Days Worked. Day Worked will be calculated using the DateLeft and DateJoined?
5. All tasks have to be completed within 50 days after it was given (DateGiven). What writes a query to show the TaskId, TaskName, DateGiven, DueDate, EndDate. DueDate will be calculated using the DateGiven + 50?
6. What writes a query to show the TaskId, TaskName, StartDate, EndDate, and NumDays. NumDays will be calculated using the StartDate and EndDate?

Let me know please help me...

Thanks

What I have tried:

C#
/* Question 11 */
PROMPT Question 11: Condition of tasks

/* Question 12 */
PROMPT Question 12: Task that are not allocated (condition)


/* Question 13 */
PROMPT Question 13: Incomplete tasks (condition)
Posted
Updated 13-Oct-16 14:12pm
Comments
[no name] 13-Oct-16 18:12pm
   
Okay so what ONE question is that you are having trouble with and what have you done yourself to try and solve it?
bearforever99 13-Oct-16 19:02pm
   
Yes, a bit. I searched for describe table structure

1 solution

It is impossible to help you with real solution because the solution depend on database structure and data which we don't know.

We can just give advices:
Each question is not so complicated.
- You need to know the database structure: tables, fields, links between tables.
- For each question display the data and analyze it. You should see that the way some field is filled tells you things about the data.
- For each question, the result of analyze is what you have to use to filter your queries.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900