數(shù)據(jù)庫基礎(chǔ)-SQL練習(xí)第一部分：通過Dbeaver登錄到Oracle中，完成以下題目，無特殊說明的，都寫oracle語句：1.按要求創(chuàng)建如下的表結(jié)構(gòu)（分別寫出Oracle與MySQL下的建表語句）建表時(shí)如果出現(xiàn)表名重復(fù)，請(qǐng)將你本地的原表刪除，禁止變更下表的表名和字段名。產(chǎn)品信息表（product）字段名稱字段含義字段類型長(zhǎng)度pdtno產(chǎn)品編號(hào)字符串50pdtname產(chǎn)品名稱字符串50factory廠商字符串50price價(jià)格整數(shù)5領(lǐng)用信息表（apply）字段名稱字段含義字段類型長(zhǎng)度pdtno領(lǐng)用產(chǎn)品字符串50applydate領(lǐng)用日期日期quantity領(lǐng)用數(shù)量整數(shù)5deptno領(lǐng)用部門字符串50領(lǐng)導(dǎo)表（leader）字段名稱字段含義字段類型長(zhǎng)度deptno部門編號(hào)字符串50deptname部門名稱字符串50leader領(lǐng)導(dǎo)字符串50物品等級(jí)表（pdtlevel）字段名稱字段含義字段類型長(zhǎng)度lowprice價(jià)格下限整數(shù)5hiprice價(jià)格上限整數(shù)5pdtlevel物品級(jí)別字符串502.在Oracle中創(chuàng)建好對(duì)應(yīng)表后，導(dǎo)入以下的數(shù)據(jù)，然后完成下述SQL題目insertintoproduct(PDTNO,PDTNAME,FACTORY,PRICE)values('C01','臺(tái)式機(jī)','聯(lián)想',3990);insertintoproduct(PDTNO,PDTNAME,FACTORY,PRICE)values('C02','筆記本','華碩',4300);insertintoproduct(PDTNO,PDTNAME,FACTORY,PRICE)values('W01','顯示器','華碩',2250);insertintoproduct(PDTNO,PDTNAME,FACTORY,PRICE)values('W02','鍵盤','羅技',80);insertintoproduct(PDTNO,PDTNAME,FACTORY,PRICE)values('W03','鼠標(biāo)','羅技',90);insertintoproduct(PDTNO,PDTNAME,FACTORY,PRICE)values('W04','投影儀','BenQ',4800);insertintoproduct(PDTNO,PDTNAME,FACTORY,PRICE)values('W05','音響','雅馬哈',120);insertintoproduct(PDTNO,PDTNAME,FACTORY,PRICE)values('W06','數(shù)據(jù)線','綠聯(lián)',20);insertintoproduct(PDTNO,PDTNAME,FACTORY,PRICE)values('S01','掃描儀','Canon',1500);insertintoproduct(PDTNO,PDTNAME,FACTORY,PRICE)values('S02','打印機(jī)','Canon',2650);insertintoproduct(PDTNO,PDTNAME,FACTORY,PRICE)values('S03','A4紙','惠普',18);insertintoproduct(PDTNO,PDTNAME,FACTORY,PRICE)values('S04','油墨','Canon',130);insertintoproduct(PDTNO,PDTNAME,FACTORY,PRICE)values('P01','內(nèi)存','金士頓',450);insertintoproduct(PDTNO,PDTNAME,FACTORY,PRICE)values('P02','硬盤','LG',550);insertintoproduct(PDTNO,PDTNAME,FACTORY,PRICE)values('P03','光驅(qū)','LG',180);insertintoproduct(PDTNO,PDTNAME,FACTORY,PRICE)values('P04','U盤','金士頓',50);insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('W06',to_date('02-01-2019','dd-mm-yyyy'),50,'E330');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('W02',to_date('08-05-2017','dd-mm-yyyy'),12,'E330');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('S03',to_date('01-12-2017','dd-mm-yyyy'),23,'E330');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('S04',to_date('01-10-2019','dd-mm-yyyy'),18,'A202');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('P03',to_date('01-09-2017','dd-mm-yyyy'),10,'D110');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('W06',to_date('11-04-2019','dd-mm-yyyy'),80,'B920');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('W05',to_date('12-04-2017','dd-mm-yyyy'),20,'B920');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('C02',to_date('15-10-2017','dd-mm-yyyy'),200,'B920');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('W06',to_date('19-07-2017','dd-mm-yyyy'),20,'A202');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('W02',to_date('23-11-2017','dd-mm-yyyy'),10,'B920');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('S04',to_date('09-10-2019','dd-mm-yyyy'),22,'E330');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('S02',to_date('09-07-2017','dd-mm-yyyy'),30,'C751');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('S01',to_date('12-05-2016','dd-mm-yyyy'),10,'D110');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('S04',to_date('18-05-2016','dd-mm-yyyy'),16,'B920');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('P02',to_date('30-06-2017','dd-mm-yyyy'),50,'A202');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('P04',to_date('29-07-2017','dd-mm-yyyy'),200,'B920');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('W04',to_date('21-10-2018','dd-mm-yyyy'),10,'E330');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('W05',to_date('20-01-2019','dd-mm-yyyy'),80,'E330');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('W06',to_date('08-05-2016','dd-mm-yyyy'),20,'D110');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('S01',to_date('12-06-2017','dd-mm-yyyy'),10,'A202');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('P01',to_date('12-10-2018','dd-mm-yyyy'),40,'B920');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('W03',to_date('03-01-2019','dd-mm-yyyy'),10,'E330');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('S04',to_date('18-10-2017','dd-mm-yyyy'),5,'E330');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('C01',to_date('30-04-2017','dd-mm-yyyy'),40,'A202');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('W03',to_date('05-10-2017','dd-mm-yyyy'),50,'A202');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('W01',to_date('02-02-2019','dd-mm-yyyy'),12,'A202');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('W05',to_date('21-03-2016','dd-mm-yyyy'),9,'A202');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('W06',to_date('21-04-2017','dd-mm-yyyy'),5,'C751');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('S01',to_date('12-05-2017','dd-mm-yyyy'),1,'D110');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('P01',to_date('12-11-2017','dd-mm-yyyy'),50,'C751');insertintoapply(PDTNO,APPLYDATE,QUANTITY,DEPTNO)values('P02',to_date('08-08-2019','dd-mm-yyyy'),22,'B920');insertintoleader(DEPTNO,DEPTNAME,LEADER)values('A202','人力資源部','張三');insertintoleader(DEPTNO,DEPTNAME,LEADER)values('B920','銷售部','李四');insertintoleader(DEPTNO,DEPTNAME,LEADER)values('C751','文案部','王五');insertintoleader(DEPTNO,DEPTNAME,LEADER)values('D110','市場(chǎng)部','趙六');insertintoleader(DEPTNO,DEPTNAME,LEADER)values('E330','設(shè)計(jì)部','孫七');insertintopdtlevel(LOWPRICE,HIPRICE,PDTLEVEL)values(0,1000,'A');insertintopdtlevel(LOWPRICE,HIPRICE,PDTLEVEL)values(1001,2000,'B');insertintopdtlevel(LOWPRICE,HIPRICE,PDTLEVEL)values(2001,3000,'C');insertintopdtlevel(LOWPRICE,HIPRICE,PDTLEVEL)values(3001,4000,'D');insertintopdtlevel(LOWPRICE,HIPRICE,PDTLEVEL)values(4001,5000,'E');執(zhí)行完腳本后，請(qǐng)繼續(xù)完成以下題目：--2.查詢比顯示器價(jià)格貴的所有產(chǎn)品信息。--3.寫出上題的mysql語句。--4.查詢產(chǎn)品編號(hào)是S開頭的產(chǎn)品的總價(jià)格，總件數(shù)。--5.查詢product表中的所有信息，按照廠商正序，價(jià)格逆序排列。--6.查詢產(chǎn)品的平均價(jià)格超過2000元的所有廠商名稱、平均價(jià)格。--7.查詢產(chǎn)品名稱是3個(gè)字的所有產(chǎn)品信息。--8.查詢領(lǐng)用次數(shù)超過2次的所有產(chǎn)品名稱、領(lǐng)用次數(shù)。--9.查詢所有產(chǎn)品的產(chǎn)品編號(hào)、產(chǎn)品名稱、領(lǐng)用總量，并按照領(lǐng)用總量逆序排列。--10.查詢領(lǐng)用數(shù)量排倒數(shù)第5的領(lǐng)用信息。--11.寫出上題的mysql語句。--12.查詢領(lǐng)用數(shù)量在[10,40]∪(50,80)的所有領(lǐng)用信息。--13.查詢比油墨領(lǐng)用總數(shù)量多但比音響領(lǐng)用總數(shù)量少的所有產(chǎn)品的產(chǎn)品編號(hào)、產(chǎn)品名稱、領(lǐng)用總數(shù)量。--14.查詢最