Question

Write a query to display the details like customer id,customer name,car id,car name which has been taken for rent for the maximum number of days .Along with these details display the maximum number of days.Given as alias name as MAXIMUM_RENTAL_DAYS.Sort the result based on customer id.

Answer 1

Answer:

in python it would be in the following way:

print("What is your customer id ?")

customer_id = str(input(""))

print("What is your name?")

customer_name = str(input(" "))

print("Which car did you rent")

car_name = str(input(" "))

print("What is your car id?")

car_id = str(input(" "))

print("How many days do you want to rent the car")

maximum_rental_days = str(input(" "))

Explanation:

Sorry i don't know sorting data in python so can't help you with that