In your lakehouse, you need to create a view that aggregates sales data from multiple tables. Describe the steps you would take to create this view, including any necessary transformations and joins. Discuss the advantages of using a view over directly querying the base tables.