I have two tables One table contains information related to student portal events and another table for weekly student activity From those two tables, I would like to be able to count the number of students that interacted with the dashboard once and again in the next week By again in the next week, I mean if the dashboard was first visited Jan 1st the next week would be between Jan 8th 14th How can this be achieved in SQL student portal events student id event date type event id 7896YD60 01 23 2022 login view 789G44VM 01 22 2022 login view 785KT3Q2 01 20 2022 dsh engage dsh invoke 78SVD53Z 01 20 2022 login view 78C9P4LP 01 20 2022 dsh engage dsh invoke 78NVX7MN 01 20 2022 login view 78U1XHS5 01 22 2022 dsh engage dsh invoke 78JWSL7D 01 22 2022 dsh engage dsh invoke 78EDG616 01 22 2022 dsh engage dsh invoke weekly student activity student id week ending date activity type weekly activity count 7896YD60 01 29 2022 login 0 789G44VM 01 29 2022 login 0 785KT3Q2 01 29 2022 login 0 78SVD53Z 01 29 2022 login 0 78C9P4LP 01 29 2022 login 0 78NVX7MN 01 29 2022 feedback submission 5 78U1XHS5 01 29 2022 assignment edit 7 78JWSL7D 02 05 2022 assignment edit 6 78EDG616 02 05 2022 feedback submission 2

Question: I have two tables. One table contains information related to student portal events and another table for weekly student activity. From those two tables, I

I have two tables. One table contains information related to student portal events and another table for weekly student activity. From those two tables, I would like to be able to count the number of students that interacted with the dashboard once and again in the next week. By again in the next week, I mean if the dashboard was first visited Jan 1st the next week would be between Jan 8th-14th. How can this be achieved in SQL?

student_portal_events

student_id	event_date	type	event_id
7896YD60	01/23/2022	login	view
789G44VM	01/22/2022	login	view
785KT3Q2	01/20/2022	dsh-engage	dsh-invoke
78SVD53Z	01/20/2022	login	view
78C9P4LP	01/20/2022	dsh-engage	dsh-invoke
78NVX7MN	01/20/2022	login	view
78U1XHS5	01/22/2022	dsh-engage	dsh-invoke
78JWSL7D	01/22/2022	dsh-engage	dsh-invoke
78EDG616	01/22/2022	dsh-engage	dsh-invoke

weekly_student_activity

student_id	week_ending_date	activity_type	weekly_activity_count
7896YD60	01/29/2022	login	0
789G44VM	01/29/2022	login	0
785KT3Q2	01/29/2022	login	0
78SVD53Z	01/29/2022	login	0
78C9P4LP	01/29/2022	login	0
78NVX7MN	01/29/2022	feedback-submission	5
78U1XHS5	01/29/2022	assignment-edit	7
78JWSL7D	02/05/2022	assignment-edit	6
78EDG616	02/05/2022	feedback-submission	2

Step by Step Solution

★★★★★

3.44 Rating (144 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To count the number of students who interacted with the dashboard once and again in ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Life is good, thought Will Stallard as he got into his truck that October morning. He could have been thinking of any one of a number of thingshis wife of seven years, his beautiful baby girl, or his...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

Project Part 3 Database Normalization SQL In this Project, you will normalize the LetsMeet data. In particular, you will eliminate redundant columns by looking for tables that fail to meet Third...

Operations Management - MNGT 401 Marks: 20 Fall 2016-2017 Working Guidelines 1. Submit original work, it should not be copy and paste, if found any such report, zero marks will be awarded. 2. It will...

BIZ3189 Management Information Systems Take-home Exam 1 The tasks in this exam aim at developing a basic level of understanding on Excel and how you can use it to develop Decision Support Systems....

I'm trying to develop Pro Forma financial statements (Balance Sheet and Income Statement) for the next two fiscal years, assuming a 10% growth rate in sales and Cost of Goods Sold (COGS) for each of...

Hello, would you be able to help me analyze the below financial statements and answer requirements 1-6? It is Kohls financial statements for 2014-2015 UNITED STATES SECURITIES AND EXCHANGE COMMISSION...

I'm using Kohl's Corporation's Annual Statement trying to answer this question. I've attached the annual report below. Assess management performance by calculating Economic Value Added (EVA). UNITED...

The questions are provided in the document attached; the relevant files are attached as well. a. For 2015, was cash provided by, or used in, Operations? b. For 2015, is Kohl's net Cash Flow from...

In at least 500 of your own words, evaluate a case study on Satyam. Why is this important for you to know in your prospective career field?

2) Periodic Deposit: $10,000 at the end of every three months Rate: 5.25% compounded quarterly Time: 10 years

The purpose of A / is to minimize handling costs and improve the speed and accuracy of order picking.

The following information is available for two different types of businesses for the 2018 accounting year. Hopkins CPAs is a service business that provides accounting services to small businesses....

On July 1, 2014, Melanie Thornhill began her third month of operating an electronics repair shop called MT Repairs out of her dad's garage. The following occurred during the third month of...

The financial statements of Trifolium Corporation for fiscal 2015 to fiscal 2017 are as follows (in thousands): Instructions (a) Calculate Trifolium's (1) Inventory turnover and (2) Average days to...

The trial balance for Darby Kite Store as of December 31, 20-1, is shown on page 608. At the end of the year, the following adjustments need to be made: (a and b) Merchandise inventory as of December...

Suppose that the government imposes a tax on heating oil. a. Would the deadweight loss from this tax likely be greater in the first year after it is imposed or in the fifth year? Explain. b. Would...

Question 1 Draw a detailed flowchart that represents the sequence of operations in the described production and quality control process. The flowchart should include: All major production steps...

Carl Conch and Mary Duval are married and file a joint return. They live at 1234 Mallory Sq. Apt. 64, Key West, FL 33040. Carl works for the Key Lime Pie Company and Mary is a homemaker after losing...

Mike purchases a heavy-duty truck (5-year class recovery property) for his delivery service on April 30, 2012. The truck is not considered a passenger automobile for purposes of the listed property...

Larry and Lisa Williams, both 33 years old, have been married for 9 years. They live at 638 Arctic Way, Fairbanks, AK 99701. Lisa's Social Security number is 445- 81-1423 and Larry's is 798-09-8526....

Acadian Bakers is a small sweets bakery in Houston, Texas. One of its products is a croissant. Acadian bakes the croissants from frozen croissants that it buys. For the sake of quality, the company...

Consider the usage of item # 14-46-506: 4 ft. Supersaver fluorescent lamps in Sterling Pulp Chemicals (now part of ERGO Worldwide) in the first 10 months of 2008. Month 2008 Jan10 Feb10 Mar66 Apr32...

A manager has just received an evaluation from an analyst on two potential forecasting methods. The analyst is indifferent between the two methods, saying that they should be equally accurate and in...