I want answer all the 3 question according to the lecture

Q1) Considering the following tables. Write the Sql code and the result of following questions using XAMPP (10 Marks) loan_number branch name amount customer_name loan_number L-170 Downtown 3000 Jones L-170 L-230 Redwood 4000 Smith L-230 L-260 Perryridge 1700 Hayes L-155 loan borrower a) Find all loan number for loans made at the Perryridge branch with loan amounts greater than $1200. b) Find the loan number of those loans with loan amounts between $90,000 and $100,000 (that is, >= $90,000 and => Data Definition Language Allows the specification of not only a set of relations but also information about each relation, ittcluding The schema for each relation The domain of values associated with each attribute Integrity constraints The set of indices to be maintained for each relations. Security and authorization information for each relation The physical storage structure of each relation on disk Data Types in SQL Fixed length character with specifiod length Variable length character string where specified matimum length Integer (afinite subset of the integer that is machime dependent Small integer la machine dependent set of the inteper domain type) Fred port number, with specified precision of digm with a digits to the right or decimal poim Floating point and double-pression flating point numbers with machine dependent precision Fating point number, with a specified procinion of allen digits Create Table Construct An SOL relation is defined in the Command create tablet (integrity constraint) integrity constraink> is the name of the relation each attribute name in the scheme of relation Dr is the data type of values in the domain of attribute Emple create table then we char(15) no ull address than 30. ape integr) Integrity Constraints in Create Table not all 10:55 1 all 4G 2 Ch4 Cont... daca escening for county control and purpose - SOL lanac for politiet perto en vieres typically correspond to the night to ma commande to accertain mata Lach wann iced the were the DBA com a tested on the mode SOL manchas SELECT INSERT DELETE UPDATES the relation SQL har langer for all those the database tech que se deyecally action that can Ingrerad by chase plates Cont... She incorporate any teams from themed det powerial apathis time to titlantail minians relational SOL si relational debut with XML OLAP Online Amitical Process Exercise Ol, Esplai Deta Definice 02. Wie eight det type in 01 Wreatiewemple 0! Explained Os. Whates of sal 10:55 1 all 4G 2) Ch4 Example Query - Find all customers who have both an account the bank tre where all customers when in the burrat dot the Additional Features of SQL SOL ho dechniques for writing Lepapes that include SOL serents to acer one or more de noe incredembedded and mc SOLCU Level predecesor ODBC Ope Taste Base City and SLPS and Modules Echoma IMS wives addi SOL for specifying systems relations and path where we called the ninio Lampa Cont... SOL transaction conta com These empecil database per fe concurrency and con SOL ha langue for per the am oses Povilopes peally come to the right so made to order Each ther the wes or the Detail on to do the privil SOL much as SELECT INSERT DELETE UPDATE the relation SOL has launch for wat wie The active database tech quer since they paid actions that tripted by sents such as datus updates Cont... 10:55 1 al 4G 2) Ch4 G The from Clause The the way Currespond to the Cutestan product and Find the Caesando ket from oum Find the name aan met mee all as the partide hech select membro from home where are Pero The Rename Operation The SOL www.aming time in the name memerlu lectoral fremme where he wants Nested Subqueries SOL provides a mechanism for the nexting of sques A is a select from where expresion that is neded within mother query A common un of queries is to perform iests for set inembership set comparisons, and set cardinality Example Query Find all customers who have both and the bank wa 10:55 1 all 4G 2) Ch4 The seleet Clause (Cont.) In the sale clue dentare select from The can obtam matic arm the and and operating on constantsoratrine ples The query selection name. 0100 from a World en relation that is the same that the of the attribute amunt is made by 100 The where Clause The chant species conditions that the out Cerpond to the compradica en la To find all im number uma made the funcil bank per than 51300 Sector Iron where brune - Terre and mon 1200 Como call he combined in the concerne antec not The where Clause (Cont.) SOL inchidea compe Emple Ford de la number of most loan wimme SW S100 ID and $ select loan from where mur between 00000 and 10000 The from Clause The cm 10:54 1 al 4G 2) Ch4 L-2 Temdes 10 Har The select Clause The weet is the death mety cochespoode the con opted the wat Lumple in the name of all bancos in the electum terciariomal alany would be Dham NO SOL E por Aran BRANCH KIME So people mo upper ce wherever we in blot - The select Clause (Cont.) SOL low duplicates relation willing to To sure the constitut de wand . Find the same el alles in the normalement weet distinctive from - The keyword all species that place see all from The select Clause (Cont. 10:54 1 al 4G 2) Ch4 L-2 Temdes 10 Har The select Clause The weet is the death mety cochespoode to the con opciof the wall Lumple in the name of all bancos in the electum terciariomal alany would be Dham NO SOL E por Aran BRANCH KIME So people mo upper ce wherever we in blot - The select Clause (Cont.) SOL low duplicates relation willing to To sure the constitut de wand . Find the same el alles in the normalement weet distinctive from - The keyword all species that place see all from The select Clause (Cont. 10:54 1 al 4G 2 Ch4 calefable wharf) un Integrity Constraints in Create Table mul primary ExampleDucia branch name as the primary lor bach crentu table branch (branch name char(15), branch Char301 integer primary ay anh.name may be Drop and Alter Table Constructs The Emmand we alle from the date The common in od tada ning table and Wurth name of the term domain All tople in the toneelsbele is the The command can who huwed bts fan ter takler drup be is the same of an amanhe al telaio Basic Query Structure ASOL or the from here Nepal Poomalaare Thiruvanthemalt TEX) 10:54 1 al 4G 2) Ch4 Data Definition Language Allows the specification of not only a set of relations but abo information about each relation, including The scheme for each relation The domain of values associated with each time Integrity constraints -The set of indices to be mamained for each relation Security and amthorization information for each relation The physical storage structure of each relation an dik Data Types in SQL Fedtchering wil im le Integer la fineste inges that made Small pie mache dependent ha of the imper Fixed points with resident with diges to the right deal Fling point of the mimhon with machine dependentem ating point with Create Table Construct An SOLilained the create table, A D ity.com imety.com Flame of the is an esame in the theme ofron Die dood values in the doom tribunal create table (teclun 3) antani, achar Integrity Constraints in Create Table