Question: Create a query that joins information from the submit event table with the loan table. The goal is to find out the total loan balance

Create a query that joins information from the "submit event" table with the "loan" table. The goal is to find out the total loan balance for each user at the time of their most recent refinance submission. Your query should include all users and their respective loan balances.
Tables Schema as Below:
submissions
columnName dataType
id INT
balance DECIMAL(10,2)
interest_rate DECIMAL(5,2)
rate_type VARCHAR(10)
loan_id INT
loans
columnName dataType
id INT
user_id INT
created_at DATETIME
status VARCHAR(50)
type VARCHAR(50)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!