Bounce Rate per Landing Page

SQLMediumMid level~15 min

Problem

**[Classic — analytics companies]**

A **bounce** = a session with only 1 pageview. Calculate bounce rate per landing page
as a percentage rounded to 2 dp. Return `landing_page` and `bounce_rate`, ordered by page.

Tables

Example rows — the live problem includes the full dataset.

sessions

session_id	user_id	landing_page

pageviews

view_id	session_id	page_url

Expected output

Your answer should return 2 rows with the columns landing_page, bounce_rate.

Starter code (SQL)

SELECT *
FROM sessions;

Solve this SQL question free

Write SQL and run it instantly in your browser — even on your phone. No signup needed to try.

Solve it now → Create free account

Solution & explanation

Create a free account to unlock the optimal solution, a step-by-step explanation, and the hidden test cases that grade your answer.