check if the query is correct(case study 2)

the first screenshot is for the query of Weekly Engagement Per Device. the second screenshot is for the query of weekly user engagement. kindly check if both the queries are correct and if not please provide guidance on any corrections needed.