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:
PROMPT Question 11: Condition of tasks
PROMPT Question 12: Task that are not allocated (condition)
PROMPT Question 13: Incomplete tasks (condition)