Table Name : booking_table

• booking_id is the primary key column for this table.
• user_id is a foreign key of the ID from the user_table.

Table Name : user_table

• user_id is the primary key column for this table.

Please answer the following question:

1. Write a SQL query to count the number of users in each user segment. Also output the no of users who booked flight in Apr 2022.
2. Write a query to identify users whose first booking is hotel booking.
3. Write a query to calculate the days between first and last booking of each user.
4. Write a query to count the number of flight and hotel bookings in each of the user segments for the year 2022.

The query result format is in the following example.