SQL for Product Managers – Phase – 2: Session 1
Resources: Presentation SQL Schema for SQL Fiddle SQL for Product Managers Assignment Below is the database schema for product hunt: […]
Resources:
SQL Schema for SQL Fiddle
Assignment
Below is the database schema for product hunt:
Users:
- ID
- Name
- Registration_date (date)
Products:
- ID
- Title
- Category
- Posted_on (date)
Upvotes:
- ID
- Product_ID
- Posted_on (date)
- User_ID
Write queries to:
- Find number of users on product hunt
- Find top 10 products by number of upvotes
- Find the number of products in each category
- Find number of products posted everyday in since 1st November
Submit your assignment (queries) here => Google Form
Ankit Shukla is the Founder & CEO of HelloPM, where he helps professionals learn Product Management, AI Product Management, and practical AI adoption. He has trained and mentored 2,000+ learners across 40+ cohorts, with HelloPM alumni working at companies such as Google, Microsoft, Amazon, Adobe, Walmart, CRED, Visa, PayPal, and McKinsey. Ankit writes about AI, product thinking, business strategy, and modern product workflows for professionals who want to build better products with AI.
More articles
One thought on “SQL for Product Managers – Phase – 2: Session 1”
Comments are closed.