INSERT time INTO table
As a data analyst you may be called upon by a developer to test a table that they have created for a particular task. In this scenario, you are a member of a team in charge of tracking the usage of an app tied to a fitness device. You are testing a new table called usage_fact having the columns user_id, usage_date, usage_duration, in that order. It will store the total amount of time that the device was used per day.
You want to insert test rows into the table to ensure that it works as intended.
이 연습은 강의의 일부입니다
Time Series Analysis in PostgreSQL
연습 안내
- Add a row to the table such that for user
1it assigns the usage date to be Dec 31, 2020, with a duration of 65 seconds.
실습형 인터랙티브 연습
이 예제를 이 샘플 코드를 완성하여 풀어보세요.
-- Insert a row into usage_fact
___
usage_fact(___)
___
(___);
SELECT *
FROM usage_fact;