Sl ne INOEX Pnogno:ra. ‘lo check the numben is prime on not To ward o. Ost ovsin? Bubble sort “la convert decimal to othen number ayslem Te count line. stealing? with Aen a. To display wands, less tan 4 chonaclers To paint sludenls necand whose sane > 456 To_count nurobew. of ‘58, ‘To’, ‘UP! To paint 10 emplayces' necond To print emdgyees necands whose salary? 20000 To_print 10 cutomen necand To_print customer newrd whose amount is locex| To cneole binasy file of students Te copy the chosoclen {nam one file te arcther| Te display number of specified characters To wnite 10 students necond Te_print stack from a. dictionary? To print jlems which cost more than 50| Te _open_o. web bnowsen using” unllib To_irnplement stack using? data shuclune SQL quaricr Integration of SQL with ylbon on O2 02 OF Os 0€ oF o8 03 10 14 12 13 14 15° 16 1F 18 19 20-2 29-32) age ne. |Remanks PIED © scanned with OKEN ScannerNo. td | Define a fnction _named__pnime() to check whether |the _numben_is__paime an_mot. aa in_nonge , C2, mum): if num Zi = _____netunn_Falae. __netum Taue___— : num = int Cinput_C “entero Serre ase if _paime (num): |____paint_Cnum,“ is_parime. Lele: | print Cem,“ @ scanned with OKEN ScannerOutput * Ds [79 24 fea tan ws, 64, 13, 22] e474 97 a 2 ve = Defineo. function named heart) to cant a let ot numbers using? Bubble caxt, def_bsant (tet): |___nslen (let) fon a_in_nange Cn) | fan _b_in_nange | lot = [29 24,92 44 6 |_pount (“BeRre_santing. | ltt = beont Clst)___ @ scanned with OKEN Scanner© Scanned with OKEN ScannerTrea Dancin nomad cout val) _in_ Python to count _-muombonof—lines_in_oteut Le “stozy-tad” cahich is stay caith_an hast — “Ae. | Git es | Total number of line: 9 [paint (Tata namben off tines *.”, te. close C) = : @ scanned with OKEN Scannerand as __ 5 Define a fanction named display af Yan 4 characlors \ |i sxead lines from 2 text file | display? those cwoonds, cohich ane len file = open (“Stary-txt” , «7d | def’ display C)* data = file-nead () | wcands= dala. splitl) | fan coin woods + if len(o)<43 | punt (2) @ scanned with OKEN Scanneres PEE Eee | | Output : Rell-no Name Maxks | 03 Student 3 500 | oF Student 7F 490 | 08 Student & 460 i) Student 9 470 08 — Yout_nead () tn _Bython a Define a —fanction— named “pead records _£n000 TT etaden tntak” and prs only? “those Students _neconds_—whe— ccared above 450 def tent—nead () — — Ple= open C“stade i) Pile. nead lin es O___———— is @ scanned with OKEN Scannerof £8 TO and UP is? 22 » ———_— Define a fanction named ESTOUPCOLNTC) in Bysthen ‘to_atad —eantents Lnom a. teat le “wniton toe» pte near and display. the cceuarence of? the wood) 28" on “To” on “up” \def_T8Toupcoun TC) @ scanned with OKEN Scanner8 ‘ma. Lanetion named —C8\e wile) oy contle the ecards fin 10 Bylton Empleyees ina ble named as “Employee. C80” and, necond must: contain —Emp-no, Emp_name, Salary? Limpant cv de? cevimnite(): —_ fi = open C “Emylogee. CSV" “newline = wr) jE CSV write Cite) loyet ramet int Gnput (“Enter Solazy?: ")) uae obj-coniter (L Emp-ne, Emp-namé, Salagy D) }_file.closeC) : oa @ scanned with OKEN Scanner09 Byten read recands from "“Emplagee. CSV" ond print only? those employees record» _esho's salon? >20000, impont csv def csvnead(): file 2 open C “Employee. CoV", C8V. neaden (File) fon i_in_obj if int Cife]) > 20000 : Pen_jin_ it “a') print Cj, end: ”) paint C) FilecloseC) @ scanned with OKEN Scanner| fevers za _—_ 1) Define a Pnction named —bin-nusiteC] tn Bjthen_eoaite the —necands Ln 10 custome ina file reamed as "Custemer-bin” and each necand must contain | Cuatno, Cust name, omeunte | fan 1 in_napge (10): | Gust nom int Cnput “Enter Cuitomer—no*”)- | ___ Cust name = input C"Enter Casts mer-name | amount = int Cinpud-C"Enter amount”) egoue ee EE © scanned with OKEN ScannerOutput = Customer-no Shopping amount 10 400000 13 420000 16 1430000 412 £80000 20 490000 at 195000 Dafne « Lcton named bin-eadd) nba ad records _Lnom customen bin and print only these | custoren neconds coho's shopping amount “& so000 impoxt_pickle def bin nead(): File= open ( “[Link]” , “xb”) tag? —____tohile True? ______data= [Link] if data [2] > loooce : fan_i_in data? print Ci, end =" ") _ pant Q) | except 2 File-close() © scanned with OKEN ScannerOutput : [itnside te binary? Hle * Roll_no + 01, Roll-no? 02, Roll-no 03, Roll_no ! 04, Roll_no 0S, Roli_no +06, Rol_no :07, Roll_no ‘08, Rl_no 709, Roll_no: 10, Name Name Name : Name Name : Nome : Name ! Name * Name = Nown ee al Ankush Sait Subhadip Aum Ankita. Anvil Pragati Saitesh By Ayushé iy a a Create a. bang? Me cith nameond oll number. a2 Search fina. given oll numbor and dis the name, a play name, if not Rand disploy. oparopaniate message impant a def bin-caxite()2 | File= open C“Stadentebin”, “cob") —fen_tin_songe (40) 2 —____ aoll-noz int Cinput (“Enten Rell_n |_ name = input C“Enter_name i”) _____pickle.damp ((Stoll_no., name), file) ee CoE ee D © scanned with OKEN Scanneree 1) Ctpeed # [Link] a sanple file. file is fan python. Datatxt This 18 a sample Fle. thes file is fan python. | Copy? atthe Lines that__cantain the _characten ‘a? fram oa $rle named as “Anticletxt” and canile it | to another file __“‘Data-txt”. fin = open (“[Link]”, “n”) Poud = open “Datartet”,“c2”) teat = Lin. read lines () fan_linein tent > —____ 7 if Une Le] in “a” 3 Pu conite (line) _ Pout-closel) fine clase C) © scanned with OKEN Scannerft 4 | Define a Rnckon named chasacl) 4 nead a Lent display the number of vocsels /consonants and. | the “Lile separately? | def charac): Outped + File = open C" [Link]”, voeels = “aeiou AEIOU No. of vowels = 8 — No of consonants = 14 tle. ead C). splitC) tent; SP iin voaela 2 veved A else + _ czced print (“nb of yowels> "vd print (“Noel consonants =” ¢) 7 ae caro @ scanned with OKEN Scanner15)| Dele a fincion named text [Link]) in Bythen cantle te necands fin _10_students_in.o tile named as students txt and cach record _must__contain _aollno, name,_manks, é def tent-canite()i “Outpub? |___ Lani in_noyge (20. © Roll-ne 2 int Cinpul C“Enten voll no: ”)) : RolLno > £ Nae © Ayush — Monks" €9 Foll-no: 2 Name: Bikash — Marks! 74 Name = input (“ Enten name: ") Roll-no-3 tome! Akash Masks" 59 Maks = int Cinpat (“Enter monks? ”) : foll-noi¢ Name? Tina Maks’ 49 Prout. eorite (“Roll_no i”, Roll-no,” "Name!" Nome," Maske Roll-no' © Nome: Arum Marks | 62 - Roll-nc*& — Name: Arigtt Marks! a3 = Roll-no!? Name? Sonajit Manks? 92 - Rolt-no'8 Name: Sohil Maaksi os {of aes Roll-no’9 — Name! Ankush Marks? 4g — Roll-no° 10 Name! Arik — Manks? at caren || @ scanned with OKEN Scanner46) | Define a. fanction named __PushC)_and —prink a _ctack. | Use the fasnelion __ Pua (vehicle), where vehitle i | a dictionayy? caritainiyy> details of vehicles |_puah Cvehiele) |_pnint Cstack) @ scanned with OKEN ScannerLF [eal | The count of element in HE | stock 157 3 | def Push Csitem) 2 ___— oe | ee op ee eee = | Notebook | fon_k_in_sitem 2 esa cane 7 if. Csitem Lk] >= Stack Ztem. append Ck) - count = count + 4 ___ __ print (“The Count of le @ scanned with OKEN Scannera2 12>) Open a web browser uring? unllib libnagy? impant untlib-nequest coeb_Ul= unllib. request. wrlopen C ‘https nnn py thenorg print (“neoult 2”, tr Creb—Unl,getcode())) @ scanned with OKEN Scanner(Dene) PyVpS uy y weg (1900 mug qs 7, > Juned (8% Fr) puaddo-yr05 (2 0c) pusddo -yros (Eb BC) prado yrs cyI=Ps fm smemynys vpep — 997) or Yprgs 0 puauaduy 0, wadbBrd—uoyghy 0 ayrecy Ser g @ scanned with OKEN Scanner20) Caite Sal _qubies for (1) t Gv) ond Lind outpul Table + TRAVEL Ra Sar queries Cy) to (vit), eshich ore based ch the tables, = Table: VEHICLE Cope VTYPE PERKM 10) volvo BUS 160 | 1o2_ | At DELUXE GUS 150 103 ORDINARY BUS 90. a 105 Suv 4o _Llot CAR 2o _Note + _ + PERKM is Fregght Changer per kilometer. *vTYPE is Vehicle Type. No] NAME TOATE xm] cove] NoP tol! Janish Kin _ 201-13 Zoo} Jo | 32 103) VYedihka that 2016-07-2/ 100] 103 | 45° 95) Tarun Ram | 2016-03-23 |350] 102 | 42 102| John Fen ___| 2016 -02-13_| 90) 102 | 40 107| Ahmed Khan _ 2ols-0/-10 | 7$| log) 2 4 tot] Raveena 2016-05-27] go| pos| 4 wf 106 Kripal Anya 2016-02-06 |200| 101 | 2 © scanned with OKEN ScannerPires NOH pel rfastceen inc nker + kM jS Kilometer travelled * NOP is number of travellovs travelled sn vebigle + TOATE is Travel___Date. 4. Coxite commend to crete the above databsse Vehitle and Travel. Mention Primasy? Key? and Fareigh key ale 2. Conite a command to see the strucctwe_of databax 3. rite command te lead _enistiyg? database. 4. To display? total fare paid b eve? bravellen. 5: Ta_display Name Vehicle Gpe, Travel date of those traveller whose travel date is between Feb 2015 to Feb 2016. Note: waite 3 diterat commands. 6. To désploy all details of a thaveller_of table travel __whose__no__is 101, 102, 106,107. 7. Te display name, date of travel, no- of person of a traveller of table travel whese na ot pores is__mane than # and code ane 102, los, 107. 3. To displey. unique no from table thavel. | 3. Reduce 5__perron— foo no- of. person and increar| value of km with 10 of those thoretin __| from Dravel_whase travel dake Is in year 20l6.| to. Calculate total km travel bp each vehicle iy _| for —2016._ —_—f i © scanned with OKEN Scanner22 41. To. dlsplay mame of” traveller who te. vellad maximum distance. 12- Te display name of havellen who pad minimum fore. 13. To display? No, name, ToATE from the table TRAVEL in descendin oad of No. 14. To display the wAme of oll travellers trom the table TRAVEL who ane Dravelling? by? vehicle vith code fod on 402 a - - 15. Te désplag he MO and __wamE bhose traeLlers from, the table TRAVEL who travelled hotween 2015 -I2-3) and __20/5-09-0L —_ — HIé- To display oll te detail» Lrom table TRAVEL _ fan the travellers who have traveled distance mane _than__400_KM in ascendiyg? ander of wok L197. Trset a rew _cith ~ following? velues a. (10g ” coniee Se ", 2020-02-06 230 25~) __b. (03, _ Kamakay", 2020-o)-16-Tig 25°) - vehicle Bype Is eangp oy type of bse < “him is mane than 150, th elumn name km to kilemebere , Addo nee column fone of? float Be. 24. 1 Update treo every? traveller, i 22- Delete those necand _ WF table TRAVEL dase _| —tateller name have _“e” between Ads _name_an_ mame canbe of 5 letter stuiling? with 6" © scanned with OKEN ScannerNAME Janish Kin Vedika. Sabai John Fen 107 | Ahmed Khan TYPE vowvo aus he Ewe Gus OROINARY aus Sov car TOATE 01s=11-13, 23. Remove 23 te entstance of? ‘able vehiele. - 24. SELECT count C+), Coo FRom TRAVEL Rkovp by Cone WavEN —covmT C*) 24 2S: SELECT OLSTIMT cone FROM _TRAVEL ; 26 SELECT A. Cone, NAME, V TYRE Rom TRMEL A, VEHICLE 8 WHERE A, CobE= 8. Cove Awd KME90; 27. SELECT AME, KM* PERKm Feom TRaver f, VEHICLE a WHERE A. Cont > B..ConeE awa A. Cooe = ‘los’ 5 28. sevecr cout CorsTame Cove) TRAVELLES: F Rom ene; 29. SELECT AME _Feom TRAVEL wit RE _wame LrkE *_. se. SELECT pvc, Cem) hom TRAVEL WHERE em >=/00 5 oRenre rabLe venrcre ( = Cope INT PRIMARY KEY, ____VTyPE_vakcHAR (Go), ___PeRun swt); [evcare ase reaver ( _No.tNT PRIMARY KEY, Name vaRcKAR (30), Toate one, _ kin _xNc, ss cooe_zwT, Z |e cr, Fi ___Forerew Kev (cone) Prrcvence venrcue (coe). © scanned with OKEN ScannerL7PAUYL wous—on-II WT TStO 198735 |e] SCP FOr ear ai) NEON OTH IAVIL WOYA S LIFT SC E=(2LU0L) WOW -ONT (3TOL,, SIT J WE IIOL || DECK] OW —202F FAO = 2075 TTVTA 3850 | VPAWYL “FIILHIN HOUT FTLYTL FIKLN* FHUN 1I37IS | {620-202 2100, 2 > BOL BMG 10 Ve, = FLUOL) ORY BOF TIAVEL = FOF FTH FOIA || V9AWL “FIFLUAA Weed 21VAL“WALN~ THIN IIIS 46¢=U0=910%,, wy ,TO=to=siot, —WIEN39~| FLvOL ONO BOD“ 7TIAGYL = POT IAAHIA 3B TPAVGL “FVININ WoYT FLYOL “3IKIN~SWUN, 1997S |S S007 SprhIA wwY , FUL WIOL, SION WH, WHITE AUIL = FOS? TILIA IIH THVIL 27395 | — 3d uoxe eo —— “uppey acu wepapp es LOOMVIL — *LeRITVIIL Fe | C fg 1 2H 39 F VISIT STTTHIN 7830 |" t 2 BH [someon] TOT] SE] ven [me vetomvee) why IAT G01] | ot wo aol | poy | 5E[ el-1o-sec) Woy} PMHEL| EOr 25 lopamseat| 70! | op | ov [oe] e-c0-seH] eay eyar Le ost | sovsnren) rot | ce | 10" fom ay yore oy lewvae| sean |omzrma| dow faraaneos|in] sxv0x] swan | ont Seo spiet] sap onan] oP pear 1-29-9197 | sag 340790 20 way *4C er-u-siot| sag an70n] ay yee s givoL| — FdALA sun 2051 oy PT |e oo0té wy paren | gat Pen any wna, | 501 oot wuss | 901) 0006 poyys vapPAA | £0! ost way uyor | Zor 00th uy ysrweg | 10r arog rr awon | oN @ scanned with OKEN ScannerExpl. Mo, | SELecT_NAME, TDATE, WoP_FRoM TRAVEL WHERE | wop>T ano cove tw (i010, 109) j3 KM KI 10 WHERE 3. | veoaTE TRAVEL 267 VoP > NOP |_year Crome )= 2016 3 oR. | vpDATE TRAVEL <1 | toate >= *20¢-01-01" ano TOATE <= “2016-12-31” vouvo gus Ac DELUXE Bus jo | 102 oRorNARY GUS 4a| cececr cone, som (xm) Fkom TRAVEL four BY CobE3— NAME io | Name "nan Ram Ahmed Khan | secect ame, mAax(xet) FRom TRAVEL a NAME TOATE 107 | Ahmed Khan 2015-01-10 | seveor name, mzn(woP"km"PERkm) FkoM VEHICLE, TI toe | Kaipal Anya goig-02-06 | |_| wweke vewreLe. Co0e = TRAVEL. Cones tg [108 | Taman fom so16-03-23 104 | Raveena Bol OS -ad 193] SELECT No NAME, TDATE Féom TRAVEL ORDER BY No BK; 103 | Vedila Sahat votg-0f- 34 {4 toz | John fen pele Oe ete | |##| Sevecr ame FRom TRAVEL wees cooe=bl_oR codes lo2; Tanish Kin pois 15. | soya ected eal cies ae eaten causa eegeeaeate { |_| sevecr wame Feom rRavel were cone IM (i0l, 102); wamE rm) It ee | SELECT No NAME, FLOM TRAVEL WHERE TORTE >= “2015-07-01 Tarun Ron Tohn Fen oo Vee Apa = @ scanned with OKEN Scanner[te | Zonish Kin vedélo. Sahat hen Khan SELECT _NQ_WAME FRoO" TRAVEL WAERE. | eao1s-oFa0t" fiw “2018-12-31” Ase j hom TeavEL weeke km > 1 08 | SeLec ‘a(108, “‘somdev sun”, 2220~03;-08, 2%, as) 6 TOATE, KM Nop) VALDES C | ewsexr rwr0 reaver (10, nae posone1=08%, 230, 25)3 nig, 130, 105, 25) | 108, “somdesan”, ay Keomakan”s |b. (107, “Sanjay. Kanmakan”, 2030-! _INSEAT_ZNTo_TRAVEL VALUES. Gor Say 25); 2010-01 rio wh UDOATE _VENTCLE. SET Flan PERKM = PERK vrvee sme “/auS" AND __PERKIM > 10 j ALTER TABLE TRAVEL CHANGE kM pueoWETRE TNT 5 rerhhoo (rane FLeaT) 3 20 fyrER TAGLE Noh" kM PERK WHERE Cook ZN 2 wr SET FARE (sexe? cone Eton vEUICLE, TWAEL WHELE vEdECLE, COOE= nested query? I | ron co0e 3 ego panne ThE "KER" 08 MAME LIKE a oo pevere Fon TRAVEL. @ scanned with OKEN Scannerwo) NAME onré |hitemete| coae| wor] fine toi] Tanish Kin gos-rt-i3| 200 [tor | 32 | mee tos| vedika Sahai |rov-er-21) 20 | 103 | 35 | noe a _VenzeLe 5 bs) Taran Ram roie-a3-13| 370 [tor |a2 | moet 1ea| ohn Fen pow-or-n to | vor | 30] moe 20 i02| Ahmed Khan sas-or-to | 95° |sog | 2 | mee tot Raveena gac-es-y\100 | os | -6 | mae to6| Kripa Arya gor-or-06| 220 |rot jag | Meee 08) somdev sun pe20-2-8|230 | 26 | 25) MOM ‘orerzer cope 102| Sanjgg Kenmaker romero] ato |tos | 25] Mit lo to. 103 NAME ToATE — |kilemetie| coe} WoP| Fane 104 -_ Teaish Kin aois-1-13 |200 | 101 | 32. NoLe) 2 | Tanun Ram gore—03-23| 370 | 102 | 32 | nove Katpal Anya go-02-06|220 | lol JIS | Nose cone NAME vryere Saafay Karmakan poro-o'-10 {230 | 105 | 2 noel “10+ AHMED RHAN. CAR __ RavEENA__— SOV. _NameE _—__— _RAVEENA @ scanned with OKEN ScannerNAME Jonish Kin Vedika Sahai Tanan Rom John Fen Ahmed Khan Raveena _ _Keipal Anga 30 012-5 ava Cem) —— © scanned with OKEN Scanner24. 29 Tonle SQL ith Python ye impostli? the mysay © caatte a. prggmm in Bython insert te ecards of? 10__staderts in a. SQL table stuoENT wri? Sar conne ctivi BP, where each now contain Roll, Name, tye, -POB, _Manks, Database mame is ScHooL.. b> canite o prsyam_in BYthen update the necands of 'studbls ina SQL table STUDENT usin? 8e6 comectivib? where —eath pow contaly Roll, Name, Bye 208, Monks. Database name js ScHoor. at 7 7 le) contte a pzegnam in _pythar te _disploy only? Those_necards _ students —wheie_age is mene than 12 and “sconce! mane — than 400 from «891 table SrovenT essing? SQL ee and_alse_desplay? te total “numberof record! found, echere cath now contain Roll, Name, tye, Doo, Monks, Detabase name io soHoot. (Usiy? feteballC)) .2:| impank [Link] as se con= [Link] Chost= ‘localhest’, database = ‘school’, —user= “nook” , passesand = “123?) [Link]—connected (): | paint C “seaccesstally” erm hart") cun=[Link]() | fox tin _nayge Co): @ scanned with OKEN Scanner(1H SO HE aye uy mon ZH NYT, Jpur a) A i Ee GPP? op pieces no pore ayy waputa, y pada gr =dn— 1 Ap seyo A SE yoayryeo] — |] 289 i () worn 1 6 paponies Arysrormos., -pured PO)pappoutoo-si-uerg} (79128, oropeep ¢0F, = promssed — © Jo0r, storm Cys0y 7020), = 4S0Y ) 2oeUUeD- 75.2400 as eo weprauuor7bsfiu—produtt |g 7 ery Ca terpenes Comp ips, quned — 7 donc | fone cenpennettee scrape eps G peparas Airysroms,, ) yard — es [ee-a0-t000 i [rsp or (yyy woo ———}- | s0-n~r008 for | verepiy anny |g (y8 Gp Bo ou01 nary poms —~|— —_ Jest | mro-po0e Jai | amen ang i: GE TRII TE) rr peaprgs equ _prasul y agmvaxa"eT — [Or |se—po-coee Ji jumphey yor [2 GP aU, y grdity par ey oe [066 | or-ro-s006 |91 | anowp mung |g Gorn wr, prey feet 7 7 Is [st | sey og | y [eck | or-so-coor Jor jeeruisemman | ¢ Gi2® vepuz,, pynduy yay = (ce PMOL TOBLG,, 7 gdh : [ 00h | si-zo-voos Jer | MS emp | x [2st | or-so-cos|sr | ma wyer jg PRT B28 aM TO a Tia @ scanned with OKEN Scanner| "name input ¢ ot atLinaad Cen ya choice: ”)) if _opt == —— —_g0ll = int wt Cmpat (“enter te neco roll noi?) | cwrcerecute (“update student sot all={} chore @ scanned with OKEN Scanner | let. fart (rel up) elif _opt == _ Sees Sted the nee name! 2) | care execute C “update student set name={} cohene —aall af 4. famat = — | elif opt == os TS |_|____age= wnt Cnput Centon the. neco age: ”) ___cur-enecute (“update student set. age={} hore : adie Ramat (ogee) an elif’ opt = 245 Z =—— an a : 7 __ dop= input Center the new dob: ”) cur. execute (* ‘update student cet deb= 13 where =int Cnput C* enter_the_neco marks! ”») _ Aanere cute (“update student set _marks= 43 _eshere_noll= £]-farmat Cnarks, up) _con-commitQ) — paint (“succes hilly? ? updated ») oe = ___ch= input Co wont te continue ? CA) ) _ con. close()as Se lhast’, exser® ‘neot’ , database ‘schoo l') revded to Nyyl Delabase ’) bed * thom feele where age >17 ar anks < 400”) atarcur R thal eocexuit, iher of recat? ”, count) @ scanned with OKEN Scanner