What SSL Traffic Means | Dataford Interview Questions

What is SSL traffic?

Using the provided request and hostname data, write a PostgreSQL query that measures SSL traffic as requests using the HTTPS protocol during January 2025.

Output

One row per configured hostname, including hosts with no matching requests
Columns: hostname, total_requests, ssl_requests, and ssl_percentage
Include only requests from January 2025, order by ssl_percentage descending, then hostname ascending

Schema

property_hosts

Column	Type	Description
host_idPK	INT	Unique hostname identifier
hostname	VARCHAR(255)	Configured hostname
property_name	VARCHAR(100)	Akamai property associated with the hostname

request_logs

Column	Type	Description
request_idPK	INT	Unique request identifier
host_id	INT	Referenced configured hostname identifier
request_time	TIMESTAMP	Time when the request was received
protocol	VARCHAR(10)	Transport protocol, such as HTTPS or HTTP
status_code	INT	HTTP response status code

Your question is What SSL Traffic Means. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem