Scribd
Upload
21 views2 pages

Segment-Level Booking Summary 2022

Uploaded by

yvrr reddy
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
21 views2 pages

Segment-Level Booking Summary 2022

Uploaded by

yvrr reddy
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Input: Booking_table Input: User_table

Booking_id Booking_date User_id Line_of_business User_id Segment


b1 23-Mar-22 u1 Flight u1 s1
b2 27-Mar-22 u2 Flight u2 s1
b3 28-Mar-22 u1 Hotel u3 s1
b4 31-Mar-22 u4 Flight u4 s2
b5 2-Apr-22 u1 Hotel u5 s2
b6 2-Apr-22 u2 Flight u6 s3
b7 6-Apr-22 u5 Flight u7 s3
b8 6-Apr-22 u6 Hotel u8 s3
b9 6-Apr-22 u2 Flight u9 s3
b10 10-Apr-22 u1 Flight u10 s3
b11 12-Apr-22 u4 Flight
b12 16-Apr-22 u1 Flight
b13 19-Apr-22 u2 Flight
b14 20-Apr-22 u5 Hotel
b15 22-Apr-22 u6 Flight
b16 26-Apr-22 u4 Hotel
b17 28-Apr-22 u2 Hotel
b18 30-Apr-22 u1 Hotel
b19 4-May-22 u4 Hotel
b20 6-May-22 u1 Flight
Output: Summary at segment level
Segment Total_user_count User_who_booked_flight_in_apr2022
s1 3 2
s2 2 2
s3 5 1

You might also like