SQL Techniques

SQL projects demonstrate comprehensive skills like:

• Retrieving Data from a Single Table
• Filtering and Calculating Data
• Summarizing the Data
• Retrieving Data from Multiple Tables Using Joins

SQL Project 1

In preparation for success planning, the AVP of Lending is reviewing the lending portfolio for Stillwater Community Bank and is interested to see the Mortgage and Auto Loans approved over $20K. I would like to review the top 10 loans with the highest loan amount and should include the following: ID of the loan, amount of the loan, type of loan, and status of the loan.

Extracting, Sorting, and Limiting Data:

SQL Project 2

The AVP of Lending would like to now see Personal Loans approved between $10K to $20K, for the top 10 loans with the highest loan amount and should include the following: ID of the loan, amount of the loan, type of loan, and status of the loan.

Extracting, Sorting, and Limiting Data:

SQL Project 3

The Manager’s Meetings have just concluded, and the Regional Director of Sales would like to get a list of all customers and when their accounts were opened. They prefer to see the list where the month, the day, the quarter, and the year the account was opened listed separately for each customer. However, they would still like to see the original account opening date. They would also like to see the list ordered by the most recent year, followed by the quarter.

Filtering Data and Date Functions:

SQL Project 4

It was brought to our attention that there were issues with accounts that were opened during the 1st 10 days of August 2022. We will need to perform back-office maintenance for these accounts. Please provide an updated list of customers who opened their account between the 1st and 10th in the month of August 2022. Please provide a list of customers and be sure to also include the original account opening date.

Filtering Data and Date Functions:

SQL Project 5

The Risk Management team needs a list of customers where their last transaction was completed on Saturdays and Sundays in the month of December 2023.

Extracting, Sorting, Limiting, Filtering Data, and Date Functions: