Please, see the following DWH diagram of an e-commerce platform.
During a user’s lifecycle, before as well as after registering on the platform, any visits of platform webpages are tracked (if possible).
In the informations table the total amount of page visits is stored (info_page_visits) for the respective timestamp of the visit and the respective used device (phone, tablet, desktop, etc.).
At the moment the user registers on the platform, a row is created in the users table. Additionally, in case the user visited the platform before, rows are created in the activities table for all of the user’s previous visits with the respective device_ID and timestamp of the visit (activity_timestamp = info_timestamp). After the registration any user activity on the platform is also stored in the activities table. The activity_is_last field is updated accordingly and always true for only one row per user in this table.
When the registered user buys something on the platform, this creates a row in the sales table and when the item is paid, a row in the payments table.
The relations between tables are defined by the names, e. g. sales.sale_user_ID refers to users.user_ID. A user does not need to have any activities or sales.
For the SQL queries, please choose any SQL dialect you prefer.
Please ignore users here, who are not registered.
2) Please write the SQL SELECT queries for the following results:
but who have also at least one additional activity with another device
3) Please write the SQL SELECT queries for the following results:
Explain in writing: What would be measured with 2 c) and what with this result?
Our motto is deliver assignment on Time. Our Expert writers deliver quality assignments to the students.
Get reliable and unique assignments by using our 100% plagiarism-free.
Get connected 24*7 with our Live Chat support executives to receive instant solutions for your assignment.
Get Help with all the subjects like: Programming, Accounting, Finance, Engineering, Law and Marketing.
Get premium service at a pocket-friendly rate at AssignmentHippo
I was struggling so hard to complete my marketing assignment on brand development when I decided to finally reach to the experts of this portal. They certainly deliver perfect consistency and the desired format. The content prepared by the experts of this platform was simply amazing. I definitely owe my grades to them.