Consistent dates in a transaction
The Idaho field office is back at it again, and wants to see how the last 10 samples between the test site 13903 in Minidoka county that we have been analyzing and site 11643 in Ada count compare.
This exercise is part of the course
Introduction to Redshift
Exercise instructions
- Open the transaction.
- Use the proper function to get the same timestamp and correctly terminate both select statements
- Close the transaction
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
--Open the Transaction
___
SELECT *, CAST(sample_date AS DATE) as date_sampled
FROM public_intro_redshift.idaho_samples
WHERE fk_monitoringlocation = 13903
-- Use the consistent timestamp function
AND CAST(sample_date AS DATE) < ___
ORDER BY date_sampled DESC
-- Add the statement terminator
LIMIT 10___
SELECT *, CAST(sample_date AS DATE) as date_sampled
FROM public_intro_redshift.idaho_samples
WHERE fk_monitoringlocation = 11643
-- Use the consistent timestamp function
AND CAST(sample_date AS DATE) < ___
ORDER BY date_sampled DESC
-- Add the statement terminator
LIMIT 10___
-- Close the transaction
___