24/4723

h - b yMSQL Fureho

prudlioud Lommard
humclien is scial
a ihe o angl1 Val
ahalonnd rulimd
amdom
p.ouuplucd Ta lurclard chu Lalld
T valus thataoh g u u m a i l a My SaL_ dalo tan u
paaemlr d
monipalali uegthu elend

com du LIKir Angh hoes punbo

LmgSaL honeland

Jngluno punclisn-wark n Lath ien clisiolual heu

uut
aataksll ond silms

Purd)
moL)

Mull Srou unhen-

puehers Theui weR o muulipl
Aglovali o a pap o houd
bo-Auml)

maL

counll)
 clAssmAte
Date
Page

Thusutlond ten u talugoiatd inla alleg unehons

matimalieal unciendclah ord a l ulntion2

Shing nlion ThN AVlag unhon y @L a Lwld

moiplali Zut h Angs_n
many ryA Aemi Lommnenly wld

@)ahCHAR {)Thhlubmd T chahat Jah lach

Asett

A-65
Eg--SELET CHARC 70 15. 67, 9) B 66
Daykay fALE
C67

bD-68
SELECTCHARC6S 5,673,674)
a-17
ACE

p
On atgleuat certaind a flaclenud Valtna sley
Amluh thy aa tpriidd a4 ioliguA
Lantalincals.ohJunk
bCoNCATC: Thu dion bena

ngs
Paclizus )
SStLBcT CaNCAT(TJanala
fpalion haclicak

StLECT cOMcATEAAME, MNAME, LNAME)

AS Ful ana"
FRot Buont
 Dafe

'Gori, merk aks

SELECT coNCA T(EAbME,
dolo l
Lalo au
lauo
o ung
OLowER/LCAS EC):ThCih
caeBtd hulutnd

CENAME)
Pg SPLECT LOwER
FReMAtucdunt

SPLECT LowER CENANE)

FRoM ATudm
WHERE FUAME 2 Gt
wHERE fNHE FNC

ULASEO):TtComuh a bung ito Llpih Cbu&drd

PPER 9ulurnLE

LCo NCAT (A' PPER(FNAHED)

LW_vPPECoNCA7 (HYFNA ME)

(e) TRIM: T hnnaAus adtrg OnoRaling Apacu

SELFCT TRIM ( onfpusa

Lompilin
(LTRZMT90mus Lad 1pasA fe t shacs

fa)RTATN: a r ralirg 2harsjL I Mpaces

 25/4723

AG 1a Sumpu Luading X.echaha clis fom e ding

SELFTTRIMhading 'xFReMxx Bnort tx3)

Dudthut

wh ema bath uaoing and Praihng hataelos hom z

alung zzz BanontazZ

SELFCT IRIM(BoTH'z FRoM z LemL D

slput> Ban Cne

wadib Sumeu Lailng a chahaclhrs pon be rng

SELECT TRIM(Tzaling xERorm "aoxBar bre71Yx ")

Lh) SUBS TRI; Tha unehion l a s l a ulag omo

SvgsTR/STR M.IT)
ulrd a bolor TR Lsjomary at ehahacl
M,n hahaclird Lorg. a MA boullu iound

Dhahachh mlgaliut Laink luetLuuends

alltharatlo bnol ing 7n 4

NULL A wm MJa hO
 Date

aulenahc.alley
ponelid a
paiLas gumtinls
at

SUBSTR('ABCDE FGl, 3,4)

SELECT 23 5 67
sutpeScDEE
SUBSTR(A BCDE F6 O4)
SBLECr
oulthut> ABCD
SELECT SUBSTR (ASCDEFG-5,1)2
-7-b-s-3-2-

pclputcoBP

nbnat SELECT SeBSTRABCDEPG 5)

nion- 2usputs CDFE 6,

SELFCT SOBSTR(ABCDEË6',S);
odat EEG

D TNSTR):T petrthus lar a ulsDumg guln dlrg

Ea SELECT TASTR LoRmlATE FLooR MOR )

123 456ig

odtpu 2

CELECT ßTNSTR 30R, LE)

FRO EMPL
 TuS TA COed, s LE)

CLERK
SALESMAN

KANAGER

ANALYST

lotld_ all Uadny Drallg nol

in teuln Apatd

CoLobRS

CIO NAME
BLACKA
WHITE
3 biVE
RED
VIOLET

INDIGD

CNAHE) AS"haglh
SELBCT CNAMZ,L ENG TH
koM CoLouRS
 CNAME 1ENGTH
BLACK
wHITE
BLVE
V ToLE T

RTD
TND360

chataseles skeilud

SELEC LEFT LLonpule 3)

SELECT CUAMB, LEFT(CNANE 2)

FROM COJoURS

CNAMEE LEFT CwAME,2)

BLACK B2
wHLIE wH
BLDE BL
NIOLETT VI
KED RE
FNOTG N

thotocls a speCod
StLECT RIGHTL"Lonpula. ,3)
 elasSMALe
Date
Page

SBRET 6ZGAL
SELECT cUANE RIGHTcNA HE,2)
FROM co bouRS

CNAM E RTGHTCCMAMP 2
3LACK CK

wHTTE TE
BLUE UE
VIo LE T ET
REA ED
TNDTGo Go

[ MID Thulo up2peing Aloilingnan t spaeilbr

boallen Twork l a Lo sUBSTR Aunch

Eg SELECT HIDCZpalie 3);

auhut-pat
Nanbicunlon -Ths urndhans guit muimiie Valus ad
permip hiiuisLel sheralans
Salud mumihie Valus dort domi a h
inhakon foscller abe.al falleuus
(atoDg-adimsmadukas Tue namdars

sELBCT MoD(3.2)AS Redes

aicdt
PoweRl ROwO- TA nchnd hlib n
Ea-SELECT wER (2,5) AS Po wER
32
 ahgumsl n Aourdul h
RoewD-hlusnd 0 Valut paiot,
[O iha beinal
nblacu Auiylt
m g m i t t d trat gjautn
tn wil
ahla ntgalinu Dan haud
hund b

Bg-SbLEC RooNDCIS,193.1)
ot-52

SELFCT RoOND(15.197.2),
Bulhat 15 20

SzLECTRoonD CS 193,2)
alau 1 519

SELBCT RooND CIE-193 -2)

20

hgumatA thonO, il sulurnd=1. T

shpmind zo uluwtnd O.VR CVgLual 4

Ea-SELbCT SIGNC-L0)

SELECT S1GNLO)

SeLECT SI3NClO]
TRUNOATE- tslhcrnk a numur utl Aomi d
buncasd

SELECT TRUNCATE (5.19 2 1D

pt- S

SELECT TRINCATELL5 6449 72,2

1514
SELECT TRUNATEGS.696478, 3
Gulut-15 64/
SELECT TRUNGA TE (IS 19628 O)
output-15

SELECT TKUNCATE CLS. 62AR78D

Bpul-10
 classeat

L4 SaRT- ull ulon u SquaM Lolfonumls

SELEc1 SakTC60
aijat

DatI Tihuchi
Thanunclions shaatnValus dat eat-cdata ij

CURDA7E / CURRENTDATEK:hulums Lwwut dal

ba fahrnal rYYYY-- DO
Y Y hMDD
duirngonuwlhur

h umbie Contd Conlet

SELECT t CURDA TE)

oiht> 2o3-o4 -29

SELBCT CURDA TEC) +lo

guthat> 2023 0S.oq

DATECO:Tbach da pahlt /Ki Adl dati o

SPLFCT DATE C'2093-04-2 9);

o30y- 29
 elassmte
Date

SELECT DATEC2223 -ok-24 el102 ie3)

taulpt> 2023 -04-24

DA YID rullend i dey fAëm a quun cdat

SELECT DA Y ('20 24-04-2q),

a u l p u 24

(dMeN TH): Tuluns tmentA Jnar giuurcelb

SELECT MoNTH (2024 0 2 a ) ;
n alhat 204

M0W TH NAMBC):ThPillwns mon drnt / De monl

pamgiaun dul

SELECT MoNTHNAME (2oy-O429)

YEAR)Tuho a wohargn Jquiun clali

SPLECT YEARC 20B-04-24
Blpat 2 0 23

DAYNAMEO Alund a nome o/ doy pan guiln

dall
SELECT DAM NAM E(213 -O4-24
adttAeliordoy
BDAYaEMoNTH
ula day aft meh Lra
ginadalta

TH2023-0k-29)

SELECT DA YoP HOW

adyilt 29

Ihd t day oluuk po

0 DAYOF WEBKL)gun.data
04-24)
SELECT DAYOFWE BR2023
adbut 7

DAY OEYEARCO: Thait Dk day a yeeh Pemgutr

ceita

SELPCT DAYOFYEAR(2093 -04 4 :

lehmal YYY-HM-DD HS MM1SS a

YYYM DD HH MMSSdtpirdlng
egonuhilh
t
conNalss l value is peuain I
Cuhunt nlent eNowC ums
thieh mnt

SELECT low C
aihat 2023-6429 011ll:36
 0 SYS DATE) T usl tkaugtndat
SELECT s Ys O:
pATT
3Qdpe- Jo2 3 -0-24 o4115: 30