elassute
O2/5la3
th-7 uryig wing SQL
ORDER BY CLAUSE ORDER BY CLAUSE 2A CLd le QunhalIa
uutt in.a poileulan oroluh ilthu
Ontoh mae lurleda_o allbilula Taluays
gthat ult
dfult Foh demcieg hduk Ruy uwsrel
DESC b wALd
(dopkayuult rdlingards) duaklayaseltin ditindizg _ohla)
For Eg- SE LECT* SELECT nemTrarks
FRoM
tndunt FkoM Andeils
ORDER BY hdmm OkDER BY marls DESC
Colipey Reutd in kobhASc LDsc)
SELECTnomi mambsclad
FRoM ucdah
ORDER B Ytlass AsCmgnls DESC
Thu o koERBYCLAUSE alkeus s o Dnchude malrdlcal
meilbumalkal paaen
bg lo play allno,mand ,brd 35 maks hou plalai
Luho hoseghu mo an 7o i hdur op
nding-hdlu ard 35 Ymanks Jn deseindng ohols
Dare
Page
35lioo A S l n
ELELT 1all no, nami, monks
FRoMatndont
wHEkE Maks>Teo
DESC
ORD ER BY clos ASC Len
a9gLqali uneliors werk upon
FunelonThe
grugal o s H c l h rd/on
On
haup c ov
ingle hcL Ond h s uhg uy
also Rnaun_as malllplhSaii
funelhlons h ghaspfeselisa
ingle rouu fochans 2mulld plahau jenck ond
D iuuta
Valu aTguuln kolum
DSUPO: Taul uduon Auen
Angl Valut,
Fon Eg-Todilay tatalmarks dgbh stndit
SELECTSUM (mok)
FRO atidnt
wHERE gndet"F
T diblay totalypous alony onployas o
gaee EL362
SELECT
SeMLghaus)
FROH Amblaye
wKBRE ghadeEL" ORgads "E2
classMAt
Dete
Pogd
AVGU: Thcaleulata ul auaga al tavelutst
puln Calumn
T-To.dieplay T_awagt oanksthe mal athdt
SELECT AVGLmnk)AsAVERAGE
wFRO Alndeb
wHERE hapl M
n) MAX C) hlusns h mezimemVlu hobaguun Calum
g - SELECT MAXmals)
ERon n d t
9 M IN0: 7rlra inlanlinnValhu a guln Colum
E9SBLECT MIN ma)
ERoM dnd
SELECT MINmels)
FROH ult
wHERE GArtr =Mj
CoUNT{): Thrulutrad Uundur haus na guutn
tolum Lhen arguminl Aua Lalumn
a n @md wil vat Lool b null valuus
h haues ncludingduplicals ard rullh
elassate
SELECT.CouNTÍma)
FRom stcbt
SELECT CouNT)
FRoM Shdnt
SELECT COUNT (DISTIACI
FRoMAStudt
SELECT CoUT (DISTueT LG)
FRoM mlnalurd
To Ca h numluruc nplayts in nhlay Tall
SELEC T COUNT()
FkOM mplayu
SELEC T SOM CuC men
FROM yoms
To Di pla miinum Lainurn Chagsnomi talaCh
SFLECT MAX(thages), MLW(thargs)
FRoMCAL
To ploy tolal luhagi agp lars 2.
SELECT Ssert (manha), AVá (ogu)
FRoM Atbrt
WHERE e y loss=124
ukak tbt valuts wil nat lucordrud y SoL ulil icling
allauing talit
SELELT CODNT(Lolm Nona
FRoM nnAlniatu
Numri Valus Tat valuu @NOLLValut DATE valus
Soog Boo0, 1500 80005o0e
mls
SELECT sUMCDTSTINCTu)
FRoN ndet
Lh cAB 020S00 10000 20000 335
uLods rut in i tall ondhhs
(a SELECT SELECTThd( SELPCT SUH) SELBCT COUNT
FRot okes FRoMdr FloM d s hom oplirg
uieh raf Jollauslirgant oe 9ghigai funhon.
asoM) 2oUNDOD @LONTO DANG0
Valuu ftm hguuim data in y SQL
AXL) NARIMUn) LARGEO bZGO
D1. SaL Lwhich fpuen lud ta diplay tout deli ord hn
Dato Timi CutO
B kasbmi a data lsse gominialhale nuds lo iaplay ho
ww Tatalpumbeh d zucond of nad yllouhoat: dh
SELECT Hoe co0NTC)
FRoABdnt
GRooP BY House
WHERE HOeLKad OL Ho= Yllo
Hull ho in indunuyng Ua ruosen a nar and wuli U
Lourqty uguggang posible coruions
SpLECT Hout CooNTC)
FRorM adsnt
GRo UP BYHast
dasi HAY TING Hauue=R KlOR Houul=Ylla '
w at z se popast oRDER6Y tlausu nSoL2 Exdlain
dhtha hul Aidalu Jolomblas
otpER BYL)A d to qhal 1 huubt hna þarlicaan erdr
iln astanoing dutsrbing hutt u onun Luy Jfalt in
sscningFonciplayitin_damdieg onds use DESC
SELEC T SELECT nons manbs
FRoM hlsnis FRoM ALudrh
ORDER EY non ORD ER mals DESL
Tabl PoReHASE
CN. CNAH E e Lla POP
2012-ob -))
Oo1 1So
2012 o2- 19
o02 Makba Hydiraliad
2024-12 -04
oo3 Na dah Palhouwia
Lo lo
202-
-
Aahil Chordiganh 50
202l- lo-20
005 LAektabak thordigarh LS
bo en T gun alh PuRCHASE wa atptt fer SaaL
SELECT lENb THLCwAHE) (DSELECT CNAME
FROM PURCHASE FRo M PURCHASE
WHERE QTY) o0 wHERE Moy THDoP) Z10
LENGTH CCNAME CNAME
Gurul
MallPa
elsssute
pate
Pege
sBLECT Me DLdly PAY(be 2)
FROn PURCHASE
wERE C= NaaDall 1
2MoRory, DAY(DoP2)
SM
s seutabh saL quny r ba holnung
y 7ehahachns hahd pom hkehatocha brieo
rem i img Tdia sagecinglese ahining
Kadet veles 23.78 ldcmal tlace
Dihley umanh e1oa /
e e tak wos
DSELECT SOBsTRZda 7,7);
SELECT TNSTR (LLconsWarld" tome "),
SREEer
SELEC T RoOND(23.18),
classate
Date
sE)FCT Hop ioo,1)D
SELECT TRIM (uswn ID)
FROH Uwrs
Eaulain Zo laleug Sal nhenk ing uilalh otamplu
eCASE
OMoD
y TRUNGA TE
DAYNA 1E
VCAS E- ICenub oaunng nbo uppuh canl and hulwn l
ULASECCoNCA TL M. FNAME))
TRTMThnus Laing.rd alcaspats nem hu lrng
SELECT TeiM/ Lonfela )
Llu MoD- ylurm moduls / lua numlus
SELET MoD(3,2) As Rinlmgen
dguk tuntalid
SELECL TRUNCATE (1S74,1)
elassmate
Date
Page
DAYNAMETtulund lo nami a/ h_day pen h guitr dalh
SELECT DAYNAME (2023 oy-24)
GROUP Y CLAUsE -TrCemlins al Dhass herarels tht hau
iolneal valus n aporlclahiol
aghie qnaup hilds Th4
ghacpng rbull nlo Cne Aum
utahd phghoop IFpop o
OaugellZ
J i h ugrel a ghouplny claus
uAd n Alet Atalnba
ton Le lors leya tglum rol nd
uwllhodute a uall f lech
houp
SELECT B CooN I()
FRoM Emplay
GRoop BY Jo9
Clacing Corolien in GkoDP BY cCLAUS E
TheHAUTNGtlaut ud Ja acra Lordilan wdh GkauP
cher laust.Tk HERE CloaL_coamait ndude aggugali
Jonclienhal uhy HAUIN6Lordlhon ouquud ui
GRoUP BY
elassmate
Date
Poge
dal SELECT JOB COON T(K,MAKbal ) MIw (hal)
FRoM Enplay
GakouP BY JoB
HAUENG 0 TNPGT TGTPRT)
TABLESTOD FNT
NAME CLASS GENDER LITY Morla
thou RoLL
X AM Karhi 43
M Jsr 440
Pralzk X
3 Mhak XI E BaRohe 4o7
XIL
Bokghe 47 D
thahulata 2
F DHN
av Parad
chika X M DH N 3o
TSR 256
haiuplorg Non
dit Hiironshu Rorch 324
Bosdonh abou tald slicdit. uwilz tk SAL_qurius lar
sllosrg
DDiMoy gerde wics hiput manks
SpLPCT GENDER MAX (tHasks). MIN(Marke)
FROM TUOENT
RoOP BY 6ENDER
ouP.Ay
pa adhts GENOER Hgdat
2
elassmAte
Date
Page
Dalag cly uic uuut mar
SELECTCITY,I N MnkA) dZaetut thonk
FRoM STUDENT
Louet ords
GRoDP BY CITY atut CITY
Kond 324
JSR 256
PaRano 4a7
OHN 362
Daplay Tatl n0. ofMal fogade udet
Dplay Talalmo oMadnspo Lad cily
SELECT GENOERlooNTC+) GENDE CoUN7()
FRoM Atedt Malk
GROUP BY 6ENDER Furale
SELECT CIIYCoUNTC)Avg (nanks)
FRoM dat
GRoOP BY CITY
stuhc fa dipla thot jols uhsis th no-Breplayp 3
SELECT6.coNTO
FkorEmbaya
GkouP AY
HAUENG CounTL) 3
te classmate
Date
Poge
Dplay thot elaues uh due! manps 250
SSELECT Clos Aug.Cmanka)
ERoN Mudont
GRODPBY clos
ttorks HAUENG Avg.Cmaks) 252
wha tommond o caleulai h Avgaghou ard tslal grsus
7
D
ro Brylayels hauug gnade E
SELECT Ava.Lgnas SUM Lgnas)
FRoM Lmplay
GRoUP By Ghade
HAVINGChade 2Et
wwia a commod l diplay autrng comtnuubr Laug. Aaloy
thou duporlm s uhvu ug Com 50 ardarg Aalotey)
20000
SELECTRDEPTNo,Avg.(CottM), Avg LSA1)
FRoM Bmplaye
GRooP BY DEPT No
HAVFNG Avg[COHM)2750 AMD AvgCSAD)20,000
o w ta dllay partmid ro. Aug Acdlesrg fan thort
Apartntnt uuu no o Lmlayez=5.
CouNTL
SELECTDEPT No Avg CSAL)
FROM lploy
GRouP 8Y AtNa
HAVZN6 co UNT C)=5
alassMAte
Date
Page
highust 2 lorust tal
schdpabmnt Dilmnte
INSA)AS
SELECT DEPTHo,ouNT(), MAX SA2)-M
FRaM eplou
GPoUP By DEPTNo
