ROUND(100.0 * SUM(website_clicks) / NULLIF(SUM(impressions), 0), 2) AS ctr_pct, ROUND(100.0 * SUM(searches) / NULLIF(SUM(website_clicks), 0), 2) AS search_rate_pct ...
This project analyzes one year of Pizza Hut sales data using PostgreSQL. The objective is to answer real-world business questions related to sales performance, customer ordering behavior, product ...