I need this answer in python.

Assignment 1) Write a program that creates a Database called Sales. The program should then go on to create three tables as follows:

Customer(customerid INTEGER, fname TEXT, lname TEXT, phone TEXT) Order (orderid INTEGER, customerid INTEGER, order_date TEXT) OrderDetails (orderid INTEGER, order_item TEXT, quantity INTEGER, price_per_item REAL)

Prompt the user to insert records into these tables. The the entered records print a report showing:

Customer Name, Order Number, Ordered Items, Items Price

at the bottom of this report, print the Grand Total for all orders.