IMPORTANT QUESTIONS OF MYSQL(BASED ON TWO TABLES)| MYSQL COMMANDS | CBSE CLASS 12 | COMPUTER SCIENCE

[@rishabhsharma7701]

mam i was so lucky that the same Q was asked on my unit test examination , thanks mam

[@SwatiChawlaofficial]

That's Great...🙏🏻😊

[@funnygusz8889]

U are my God. Thx for giving a superb content free of cost.. Big salute Ma'am...

[@SwatiChawlaofficial]

It's my pleasure.. Thanku..

[@rithm3470]

Why didn’t I find u earlier , this is one of the best channels for Computer science , love u ma’am

[@SwatiChawlaofficial]

Thanku so much.... Share it with others too...

[@gytricky4987]

Mam , my 12th journey is going to end but i just want to thankyou from the bottom of my heart as in the beginning of 12th , cs was my weakest subject but if we talk about present , it is one of my favorite subject, thankyou ma'am , thankyou❤

[@SwatiChawlaofficial]

Glad to hear that.... Thanku

[@Sandeep-bb5bc]

I shared this channel to all my friend and we are so lucky to find you mam... Love your videos ❤️ its help a lot bcz our schl comp teacher teach us so bad that the whole class complain to the principal but now its seems so easy to understand bcz of your teaching mam... Thank you mam ❤️ you made our learning so easy ❤️❤️

[@SwatiChawlaofficial]

Thanks for sharing.... Keep watching...😊

[@aishanasim1900]

So pleased to see you mam accomplishing great things.....God bless you mam💐💐🏵️🏵️🌻🌻❤️❤️👸🎉🎈🎇🥇🎇🔥🔥

[@SwatiChawlaofficial]

Thanks a lot 🌻❤️❤️

[@aishanasim1900]

Your welcome mam😊

[@Teenu]

mam thanks i watched complete playlist of mysql and finding cs quite easy because of you. very very thanks mam......

[@SwatiChawlaofficial]

Glad to hear that Keep Watching...

[@soni4064]

mam aap bhot aacha padhate h ................thank u very much

[@SwatiChawlaofficial]

My pleasure.. Keep watching..

[@therick-ju8gl]

Really you are legendary teacher

[@SwatiChawlaofficial]

Thanku so much...😊🙏🏻

[@Adhixxyy]

101K LESSGO 🎉❤

[@tusharkumar1293]

Why this channel is so underrated 😭❤️

[@SwatiChawlaofficial]

Please share it with others too

[@Arpitaasharnaa]

Aap ke pass computer thi class 12 me agr thi to plz batana computer me acha score kese kre ...plz I really need help

[@me_zalaya3995]

You are the best of the best miss 🙏 Thank You 🥰

[@SwatiChawlaofficial]

Thanks and Welcome

[@Talksdaily678]

lekin * toh all information me aata hai 1:45???

[@sakshikhatta9040]

Mam one more doubt Mam agar humare pass ek table hai Jese hum se ek question push a ki Display mobile supplier and quantity of all mobile except 'mboo3' Mam except wale case mai kya karte hai Can we DELETE command in this case

[@SwatiChawlaofficial]

Delete commamd will not be used. Use with not equal to Operator

[@SwatiChawlaofficial]

MYSQL: kzbin.info/aero/PL5Raijva2y4S2sDeMIMu1kAVjwjgWyvyK For detailed explanation... Click on the above link

[@Vibe_finder]

14:51 maam yaha per count(*)>=2 ka matlb kya hai?

[@heisenbugs_not_uncertain]

In this question it is grouped by destination so count(*) on basis of destination means counting the no of destination in the table ..suppose if there is only one manager in tht table then count(*)>2 will not return manager as result since it occurs only 1 time. .

[@khushiverma9066]

Mam cannot we write salary +benefit as "total salary" in the query when we are naming the column as total salary??

[@SwatiChawlaofficial]

yes

[@sudhirchandra1085]

Thank you so much ma'am....🙏🏼🙏🏼🙏🏼

[@yourhelper-mehak5745]

Hello mam.... thank you for the video.....it was really helpful.....i want to ask you that Jin que mae query likhi hae.....wo bhi hum perform krke likh skte hae

[@SwatiChawlaofficial]

in practical ?

[@yourhelper-mehak5745]

@@SwatiChawlaofficial yes

[@yourhelper-mehak5745]

Ke Jin que mae hame output likhni hae....woh bhi hum query lga ke dekh skte hae computer pae....and then write the results

[@iMxNU]

thanks ALOT:)

[@SwatiChawlaofficial]

You're welcome!

[@Arpitaasharnaa]

Aap ke pass computer thi class 12 me agr thi to plz batana computer me acha score kese kre ...plz I really need help

[@empireofeducation2244]

Sabhi log mam se pdo bilkul shi pdati h exam me top kroge confirm

[@SwatiChawlaofficial]

Thanks 🙂

[@sportsspirit8471]

U r great mam

[@SwatiChawlaofficial]

Thanks a lot

[@sportsspirit8471]

@@SwatiChawlaofficial mam I didn't think that I suppose to be a good python coder in class 12..... I only watch your 42 videos of important questions sachiii m mjaa aa gya questions krke

[@ankitasah269]

Thank you mam ❤

[@SwatiChawlaofficial]

Most welcome 😊

[@deskman7]

badhia

[@SwatiChawlaofficial]

Thanks

[@gauravpayal498]

Thank u so much mam..

[@SwatiChawlaofficial]

Welcome..😊🙏🏻

[@saumyasingh...8441]

Thank you so much mam 🙏

[@SwatiChawlaofficial]

Most welcome 😊

[@VardhanMittal]

Mam to show min salary of clerk and manager cant we use where designation= clerk or manager instead of group by. Pls reply

[@SwatiChawlaofficial]

no...if u will write this query...u will get the output as min salary from either clerk or manager... but we have to find for both.. for that use group by with having.. to explore more...i suggest u to execute practically.. if possible...

[@VardhanMittal]

@@SwatiChawlaofficial ok mam tnx

[@Aves7]

Thanks sir

[@EsotericEntertainment2004]

8:22,1:40

[@therick-ju8gl]

Mam aaap questions paper solving ki series chalaooo plz

[@SwatiChawlaofficial]

Already started..plz Check the Playlist with name Sample Paper And chapter wise PYQ are uploaded in Playlist of that chapter.. Plz check

[@utpalm9453]

Does order of output matter?

[@SwatiChawlaofficial]

no

[@Hustler2025]

Thank you

[@SwatiChawlaofficial]

You're welcome

[@Divvv-no8vg]

Mam what is a purpose of sql command SHOW DATABASEs;

[@SwatiChawlaofficial]

It will display the list of all the databases.. kzbin.info/www/bejne/paOqkqmYbqpsq9k For more detailed explanation, plz watch this video

[@Divvv-no8vg]

@@SwatiChawlaofficial thanku mam🤗

[@nischalgupta5319]

Thanks a lot dear maam😊

[@SwatiChawlaofficial]

Most welcome 😊

[@nischalgupta5319]

@@SwatiChawlaofficial maam pdf kaha milegi iski ?

[@SwatiChawlaofficial]

@@nischalgupta5319 Sure..You can enjoy special perks by joining the membership. Have a look at this. kzbin.info/door/2vH9rqGh-fJELF8acGfBdwjoin

[@raviarya5293]

Can't we write where designation ="manager" and designation ="Clark" in 6th query??

[@SwatiChawlaofficial]

where designation ="manager" or designation ="Clerk"

[@raviarya5293]

@@SwatiChawlaofficial No ma'am.. I am not asking that😌

[@raviarya5293]

@@SwatiChawlaofficial you wrote where designation in "manager", "clerk" So, can't we write where designation ="manager" and designation = "cleark"

[@SwatiChawlaofficial]

@@raviarya5293 yes...we can write..but in place of and operator.. or operator will be used..

[@raviarya5293]

@@SwatiChawlaofficial Ohkay ma'am.. Thank you so much ma'am... Keep supporting. You are a true gem☀️

[@siddharthsharma7006]

Mam Can we also display minimum salary of managers and clerks by this query SELECT MIN(SALARY) FROM DESIG WHERE DESIGNATION ='MANAGERS' AND 'CLERKS' ;

[@SwatiChawlaofficial]

Select MIN(salary), designation from TableName group by Designation having designation in ('manager','clerk');

[@siddharthsharma7006]

@@SwatiChawlaofficial ok thanks mam👌

[@parulpurbey2724]

Plss even provide notes of the sessions

[@SwatiChawlaofficial]

Sure..You can enjoy special perks by joining the membership. Have a look at this. kzbin.info/door/2vH9rqGh-fJELF8acGfBdwjoin

[@Auxin11.11]

Mem please provide pdf or you can make one telegram channel ❤️ whr you can post your pdf

[@SwatiChawlaofficial]

Sure..You can enjoy special perks by joining the membership. Have a look at this. kzbin.info/door/2vH9rqGh-fJELF8acGfBdwjoin

[@rajpathak38]

ip ki daldio sereis and dataframe plzzzz requireddddd

[@thedarkdemigontragic3534]

Why we use w-id?

[@Sourab_kumar_]

Mam please hide answer for better understanding

[@SwatiChawlaofficial]

Ok.. sure

[@fahadjoseph3564]

This question is MIT(most important thing).

[@krishnanikhil2507]

in beginning there were some questions with answers mam

[@muneerpathan9301]

I would like your video 100 times if I would have 100 account

[@SwatiChawlaofficial]

thanku so much..

[@deathsagar1298]

bhai thi to 10k aur 20k ke beech ek..wo kyu nhi show hui?

[@deskman7]

exam ke kuch ghante pehle ye dekhraha hu hoping that i pass

[@SwatiChawlaofficial]

Definitely.... All the best 🙂👍

[@Arpitaasharnaa]

Aap ke pass computer thi class 12 me agr thi to plz batana computer me acha score kese kre ...plz I really need help

[@krishnanikhil2507]

mam everything was good but pl remove answers mam

[@SwatiChawlaofficial]

thanks...sure..

[@Nirbhayyyy]

Thank you mam 💞

[@SwatiChawlaofficial]

Most welcome 😊