SQL practice: Date Functions
Chapter 20 · 9 questions · included in full access
Question 1 · easy
Solve it in your browserShow every order's date with just its month number.
Question 2 · easy
Solve it in your browserCount orders per month using DATE_TRUNC.
Question 3 · medium
Solve it in your browserShow each order with how many days elapsed between order_date and the milestone date '2024-06-01' (named days_ago).
Question 4 · medium
Solve it in your browserCount how many employees were hired in each year.
Question 5 · medium
Solve it in your browserFind all orders placed in March 2024.
Question 6 · medium
Solve it in your browserShow each order date formatted as something like Jan 2024.
Question 7 · medium
Solve it in your browserFind customers who signed up before 2019.
Question 8 · hard
Solve it in your browserShow the earliest and latest order dates in the table.
Question 9 · hard
Solve it in your browserCount stock transfers per month.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing