Write an SQL query to calculate the number of jobs reviewed per hour for each day in November 2020.

Sure, here is a step-by-step guide on how to write the SQL query:

1. Identify the table and columns: First, you need to know the name of the table that contains the job reviews data. For this example, let's assume the table is called job_reviews and it has a datetime column called review_time.

2. Extract the date and hour from the datetime column: SQL provides functions like DATE() and HOUR() to extract the date and hour from a datetime column.

3. Group by date and hour: To calculate the number of jobs reviewed per hour for each day, you need to group the data by date and hour.

4. Count the number of jobs: Use the COUNT() function to count the number of jobs reviewed in each group.

Here is the SQL query:

SELECT 
    DATE(review_time) AS review_date, 
    HOUR(review_time) AS review_hour, 
    COUNT(*) AS num_jobs_reviewed
FROM 
    job_reviews
WHERE 
    review_time >= '2020-11-01 00:00:00' 
    AND review_time < '2020-12-01 00:00: