Help with questions i'm tying to validate from interview [message #677906] |
Mon, 21 October 2019 22:07 |
|
jricks
Messages: 1 Registered: October 2019
|
Junior Member |
|
|
Can someone please help me with these questions? These were interview questions i just want to make sure i got right.
1: Pull all loans with the highest app_value
2: Pull all loans with Borr_name & first App_value
3: Update all records with Null date to todays date
4: Build query to pull only loans that start with the letter B and all matching App_Values
5: Display only loans and show the 2nd highest app_value
Table A
Loan_Num App_Value Date
123 100 1/1/2000
456 750 6/30/2015
123 150 4/1/2018
987 100 NULL
456 725 7/31/2015
123 200 NULL
Table B
Loan_Nbr Borr_Name
0123 Bob
4311 Jake
0678 Sam
0789 James
0456 Jordan
0126 Ben
0987 Sara
|
|
|
|