booking_platform_id booking_platform_name NumberOfMale Passengers NumberOfFemale Passengers
Make my trip
Trip Ninja Capterra
1
1
2
2
0
4
0
3
3
3
3
2
4
4
Cheap Air Flight Gorilla
3
3
5
5
2
5
6
6
Opodo
4
2
7
7
At airport
1
5
8
8
Amadeus
1
5
9
9
Expedia
3
5
Picture 7.1
Question 8:
Create a stored procedure named P1 to calculate the number of bookings made by a given passenger where passenger_id int is the input parameter of the procedure and numberOfBookings int is the output parameter of the procedure.
For example, when we execute the procedure P1 with passenger_id = 1 by using the following statements, the result should be as in the following figure:
declare @x int
exec P1 1, @x output
select @x as NumberOfBookings
Zoom
FUO
+ 100%
Close
