its asking for complete weeks so its B

B. Rounding up gives then employees extra days for their "complete" weeks. B would make more sense.

b is correct

A & B, Both are correct. More precise is B. The requirement “output must be sorted by the number of weeks, starting with the longest” means the sorting order MUST be DESC on Tenure (High -- Low) Since in C & D, the order by tenure will adopt ASC by default, it will be from low -High so lowest tenure will be on top of output and highest tenure at bottom.

B is the correct answer

Are you kidding me? Why paying for incorrect answers? Obviously the answer is B!

Answer B. Complete weeks with trunc

B would be more accurate since it does not give extra days by rounding

how to filter department = 90 when theres no Department or Dept_ID in the table... All options must be wrong.

Answer is B, complete weeks.

I would say A. If we have 5 working days in a week, then Round will give us the correct result. And as we were asked to show employees, who serves longer, first, then we should order by desc. So, I do not understand why correct answer is C ...

Answer is B, complete weeks.

B correct

Task ask for number of COMPLETE weeks - so TRUNC , not ROUND function should be used Answer is B

B is correct they said de longuest with means the hightest number of weeks

B is the correct because the sorting is DESC

B is the correct answer