Need to answer for each question

Question

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 13-Oct-16 10:27am

bearforever99

Updated 13-Oct-16 14:12pm

Add a Solution

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Patrice T · Accepted Answer · 2016-10-13T14:12:00

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.