mups.//
www.opodo.com
Picture 6.1
Question 7:
6 of 6
Paper No: 7
Write a query to display booking_platform_id, booking_platform_name,NumberOfMale Passengers, NumberOfFemale Passengers corresponding to each booking platform where NumberOfMale Passengers and NumberOfFemale Passengers are respectively the number of distinct male passengers and female passengers who made bookings for flights to fly from 'Germany' to another country via the corresponding booking platform as in the following figure.
booking platform_id
booking platform_name
NumberOfMale Passengers
NumberOfFemale Passengers
23456 1 4 6
1
2
Make my trip Trip Ninja
2345
Capterra Cheap Air
0
4
3
0
3
2
4
3
3
5
Flight Gorilla Opodo
2
5
6
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
+ 81%
Close
