Details of the analysis done

AverageRevenue.sql: Calculates the Average of Total revenue

Change data.sql: Changes TotalPrice from VARCHAR to Float or decimal

Count of orders.sql: Counts the number of orders.

numberofnulls.sql: Counts the number of null values in the CouponCode

Revenue analysis for delivered orders.sql: Analyses the total revenue by each payment method and the average of each

Select.sql: Selects all the data in the file

Select_three.sql: Three elements are selected from the file

SumTotalPrice.sql: Calculates the Total Revenue for all transactions

Totalabove500.sql: Selects all transactions with a total price above 500