Rename Operation •The SQL allows renaming relations and attributes using the as clause:  old-name as new-name •Find the name, loan number and loan amount of all customers; rename the column name loan-number as loan-id.
{"Image DocumentName": "Where Clause (1)", "Image ImageDescription": "SQL Includes a between comparison operator in order to simplify where clauses that specify that a value be less than or equal to some value and greater than or equal to some other value. Find the loan number of those loans with loan amounts between  90,000 and  100,000 (that is,  90,000 and  100,000) select loan-number. from loan. where amount between and", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}