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:

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:

1. Find number of users on product hunt
2. Find top 10 products by number of upvotes
3. Find the number of products in each category
4. Find number of products posted everyday in since 1st November

Submit your assignment (queries) here => Google Form