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