Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases Reporting with SQL Date and Time Functions Review: Reporting with SQL

Posted by Kohane Kagami
Kohane Kagami
12,390 Points

Please help me with this question.

The ( ) keyword is used after the ORDER BY clause to order dates from the most recent to the furthest back in time.

3 Answers

Jonathan Grieve
MOD
Jonathan Grieve
Treehouse Moderator 91,253 Points
Jonathan Grieve
Jonathan Grieve
Treehouse Moderator 91,253 Points

Hi there,

When ordering dates you can explicitly state whether the order is in Ascending or Descending order with 2 keywords,

ASC

or DESC

So the answer you should give to the quiz is DESC.

Steven Turturo
Steven Turturo
6,890 Points
Steven Turturo
Steven Turturo
6,890 Points

It would be a keyword in which to order your selection an example:

SELECT username, points
FROM users
ORDER BY username (Keyword)

Hope that helps.

Kohane Kagami
Kohane Kagami
12,390 Points
Kohane Kagami
Kohane Kagami
12,390 Points

Thank you very much, Jonathan and Steven! :)