Find the time zones
You can expect to utilize your data analysis skills to help developers diagnose code issues.
In this scenario, you are on a web browser development team investigating a bug. The issue is made more challenging because many users do not provide location. However, it is possible to segment users by time zone. Bug reports indicate that the issue affects users residing in time zones with a UTC offset between +5:30 and +5:45; moreover, the affected time zone is thought to have either a 30- or 45-minute offset.
The team lead wants you to provide the names and UTC offsets of the potentially affected time zones.
Diese Übung ist Teil des Kurses
Time Series Analysis in PostgreSQL
Anleitung zur Übung
- Retrieve the
nameandutc_offsetof time zones having a UTC offset between +5:30 and +5:45 hours, ordered by name from thepg_timezone_namestable.
Interaktive Übung
Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.
-- Select the name and utc_offset
SELECT name, ___
FROM ___
-- Filter for offsets between +5:30 and +5:45 hours
WHERE ___
ORDER BY name;