Cross Platform Learning Behavior Analysis

Problem Statement

Problem Description An online learning platform wants to understand how different device platforms affect student engagement and learning outcomes across course categories. Without platform-specific insights, the company cannot optimize content delivery formats, design effective learning experiences, or allocate development resources to improve performance across devices. Task Write one SQLite 3 query that groups enrollments by platform (Web, Mobile, Tablet) and course category, computes the engagement metrics below for every group, classifies each group's engagement pattern, and recommends a content format. Input Tables Table: students (this query does not use it) Column Type Description student_id INT Unique identifier for each student student_name VARCHAR Name of the student email VARCHAR Email address country VARCHAR Country city VARCHAR City education_level VARCHAR Highest education level attained age INT Age membership_type VARCHAR Type of membership Table: instructors (this quer