PRACTICE QUESTIONS ANSWERS 20:50 2021 (A).... SELECT * FROM TEACHERS WHERE SUBJECT= 'COMPUTER' ; (B).... SELECT * FROM TEACHERS WHERE SALARY BETWEEN 20000 AND 35000; (C).... SELECT SUBJECT FROM TEACHERS WHERE AGE > 40; (D).... SELECT NAME FROM TEACHERS ORDER BY NAME; 2022 (1).... 4 FIELDS AND 4 RECORDS (2).... (I) SELECT SALE_ID , PRICE FROM SALES WHERE DISCOUNT > 1000; (2) SELECT * FROM SALES ORDER BY PROD_NAME; (3) SELECT PROD_NAME AND SALES PRICE FROM SALES WHERE SALES PRICE=PRICE -- DISCOUNT; .......THANKS FOR YOUR COORDINATION AAKASH SIR........
@@maahirahmad8889 the question says display the list of "names" of the teachers in alphabetical order So, its SELECT NAME FROM TABLE TEACHERS is appropriate
2021 a. SELECT * FROM TABLE TEACHERS WHERE SUBJECT='COMPUTER'; b. SELECT * FROM TABLE TEACHERS WHERE SALARY BETWEEN 20000 AND 35000; c. SELECT * FROM TABLE TEACHERS WHERE AGE>40; d. SELECT * FROM TABLE TEACHERS ORDER BY NAME;
20:49 select * from teacher where subject='IT'; Select * from teacher where salary between 20000 and 35000; Select subject from teacher where age>40; Select * from teacher order by name;
20:49 a. SELECT * FROM TEACHERS; b. SELECT * FROM TEACHERS WHERE SALARY BETWEEN 20000 and 35000 ; c. SELECT SUBJECT FROM TEACHERS WHERE AGE > 40 ; d. SELECT NAME FROM TEACHERS ORDER BY NAMES ; 21:00 |. SELECT SALE_ID , PRICE WHERE DISCOUNT > 1000 ||. SELECT * FROM SALES ORDER BY PRODUCT NAME ; |||. SELECT PRODUCT NAME , PRICE WHERE PRICE = 'PRICE' - 'DISCOUNT'; Its all you hard work that im able to answer this 😊thanks for securing my 50 marks....youre literally a lifesaver Tomorrow is my exam...wish me luck plsss..👍
d. Is it NAME or NAMES III. We use inverted commas when the value is text but here Price - Discount (both are numbers ) so don't use inverted commas Everything else is perfect! good luck!
*1st PYQ solution* 😄 a) SELECT * FROM TEACHERS WHERE SUBJECT = 'COMPUTER'; b) SELECT * FROM TEACHERS WHERE SALARY BETWEEN 20000 AND 35000; c) SELECT SUBJECT FROM TEACHERS WHERE AGE > 40; d) SELECT NAME FROM TEACHERS ORDER BY NAME; *2nd PYQ solution* 1} a)There are 4 feilds and 4 Records. 2} i) SELECT Sale_Id, Price FROM Sales WHERE Discount > 1000; ii) SELECT * FROM Sales ORDER BY Prod_Name; iii) SELECT Prod_Name, (Price - Discount) AS Sell_Price FROM Sales
@@KumariPrachiMahato [ SELECT Prod_Name, (Price - Discount) AS Sell_Price FROM Sales ], deduct karne ke liye brackets mei Price se Discount Subtract kar diya hai, thats all I can recall after a year 😅
for q,1 1. select*from teachers where teacher = 'computer' ; 2. select*from teachers where salary between 20000 and 35000 ; 3. select subject from teacher where age >40 ; 4. select name from teacher order by name ; q.2 1. select sale_id , price from sales where discount >1000 ; 2. select * from sales order by prod_name ; 3. select prod_name , price-discount from sales as price-discount ;
Select * from Teachers where subject = 'Computer' ; Select * from Teachers where salary between 20000 and 35000 ; Select * from Teachers where age > 40 ; Select* from Teachers Order by name ;
Sir ji I think in 00:13:47 there must be, (order by desc qty) by the way you are like a boon for student like me who had started it before 2 to 3 days 😅😅 thankuu sir 🤗🤗
a. SELECT * FROM TEACHERS WHERE SUBJECT= 'IT'; b. SELECT * FROM TEACHERS WHERE SALARY BETWEEN 20000 AND 35000; c. SELECT SUBJECT FROM TEACHERS WHERE AGE>40; d. SELECT NAME FROM TEACHERS ORDER BY NAME; 1. FEILDS- 4 RECORDS- 4 2. i. SELECT Sale_ID, Price FROM Sales WHERE DISCOUNT >1000 ; ii. SELECT * FROM Sales ORDER BY Prod_Name; Can you please give the answer from the last one. thanks
Sir thank u today is my exam and i watched ur video 1hr before exam and it helped me to attain all sql query questions mark. Sir when and how u completed ur syllabus for IITB
Sir could you please please give the answers of both the hw questions since there ia a lot of confusion related to the questions like (iii) in 2nd question and (d) in 1st question. Please sir.
1.) A ) SELECT * FROM TEACHERS WHERE SUBJECT = 'COMPUTER' ; B ) SELECT * FROM TEACHERS WHERE SALARY BETWEEN 20000 to 35000 ; C ) SELECT SUBJECT FROM TEACHERS WHERE AGE > 40 ; D ) SELECT * FROM TEACHERS ORDER BY NAME ;
2021 ka (a)ka answer select * from TEACHERS (b) select* salary from TEACHERS where salary between 20000 , 35000 (c) select* from TEACHERS where age > 40 years (d) select * name from TEACHERS ordered by alphabetical order
At 8.48 we have to insert new row ...so shouldn't we have to write insert into class rows Sir don't we only have to write table name ...or we have to write table then table name
(a) SELECT * FROM TEACHERS WHERE SUBJECT = 'COMPUTER'; (b) SELECT * FROM TEACHERS WHERE SALARY BETWEEN 20000 TO 35000; (c) SELECT SUBJECT, NAME FROM TEACHER WHERE AGE > 40; (d) SELECT NAME FROM TEACHERS ORDER BY NAME ;
Jab hume saare fields select karne hotey hai tab hum star use karte hai aur jab koii specefic column select karna hota hai tab hum example ke liye ( SELECT NAME ) isme humne siirf name select kiye hai tohh siirf name waali field dikhegi
13 march wale students attendance..😊👍
All the best!! 🔥
95% 😂😂😂
Me😂😂
All the best bro
school mein attendance nhi yaha Kai ka attendance
13:47
Order by qty desc ;
You forgot to mention DESC command
Btw great explanation
I had same doubt, lol
same
Same
Bhai tujhe Patna Nhi tu ne kitba bara kaam kiya hai
🎉🎉🎉🎉❤❤❤
Yeah i was thinking the same...!!
This man is saving our 50 marks👀❤
Yup
True 😌
final exam day after tomorrow. hopefully score 90+
Kitne aaye bhai
Kitne aaye bro
PRACTICE QUESTIONS ANSWERS 20:50
2021
(A)....
SELECT * FROM TEACHERS
WHERE SUBJECT= 'COMPUTER' ;
(B)....
SELECT * FROM TEACHERS
WHERE SALARY BETWEEN 20000 AND 35000;
(C)....
SELECT SUBJECT FROM TEACHERS
WHERE AGE > 40;
(D)....
SELECT NAME FROM TEACHERS
ORDER BY NAME;
2022
(1)....
4 FIELDS AND 4 RECORDS
(2)....
(I) SELECT SALE_ID , PRICE FROM SALES
WHERE DISCOUNT > 1000;
(2) SELECT * FROM SALES
ORDER BY PROD_NAME;
(3) SELECT PROD_NAME AND SALES PRICE FROM SALES
WHERE SALES PRICE=PRICE -- DISCOUNT;
.......THANKS FOR YOUR COORDINATION AAKASH SIR........
In 2022 there is 4 rows and 4 fields
@@maahirahmad8889yes u shouldnt count top one for fields
@@karthikbs4498 yes
@@karthikbs4498 i have one more confusion in 2021 q (d). Whether we have to write star or name , plzz reply
@@maahirahmad8889 the question says display the list of "names" of the teachers in alphabetical order
So, its SELECT NAME FROM TABLE TEACHERS is appropriate
2021
a. SELECT * FROM TABLE TEACHERS WHERE SUBJECT='COMPUTER';
b. SELECT * FROM TABLE TEACHERS WHERE SALARY BETWEEN 20000 AND 35000;
c. SELECT * FROM TABLE TEACHERS WHERE AGE>40;
d. SELECT * FROM TABLE TEACHERS ORDER BY NAME;
Bhai c me keval subject show krna h
Select SUBJECT FROM TEACHERS WHERE AGE>40;
Right💯@@ptarnavsharma0510
@@ptarnavsharma0510 bhai a me subject = IT aayega na
@@Gauransh399 nhi bhai table ke data ke hisab se entry likhte hai
Superrrrrr duper explanation. Saved my 4 marks out of 50 in final exam.
धन्यवाद मास्टर jiiii
par bhai kal toh exam hai na☠ anyways all the best guys
nah bhai aaj (its 1:25 am ;)
it's 2:17am 😂
It's 5 am 😂
@@mr.gaming879its 5:15 am😂
5.52😅
20:49
select * from teacher where subject='IT';
Select * from teacher where salary between 20000 and 35000;
Select subject from teacher where age>40;
Select * from teacher order by name;
20:49
a. SELECT * FROM TEACHERS;
b. SELECT * FROM TEACHERS WHERE SALARY BETWEEN 20000 and 35000 ;
c. SELECT SUBJECT FROM TEACHERS WHERE AGE > 40 ;
d. SELECT NAME FROM TEACHERS ORDER BY NAMES ;
21:00
|. SELECT SALE_ID , PRICE WHERE DISCOUNT > 1000
||. SELECT * FROM SALES ORDER BY PRODUCT NAME ;
|||. SELECT PRODUCT NAME , PRICE WHERE PRICE = 'PRICE' - 'DISCOUNT';
Its all you hard work that im able to answer this 😊thanks for securing my 50 marks....youre literally a lifesaver
Tomorrow is my exam...wish me luck plsss..👍
d. Is it NAME or NAMES
III. We use inverted commas when the value is text but here Price - Discount (both are numbers ) so don't use inverted commas
Everything else is perfect! good luck!
@@aakashsingh.so so thankyou for your feedback....I'll improve that......once again thankyou 😊
Thanks for ur answers ...all this helped me alot...mahadev aappe kripa kare...❤❤
Jai shree ram
Radhe radhe
nice bro
Bro l gess you forget to.write from sales
Bhai aapne 6:54 ko semicolon (;) nahi dala, btw thanks for teaching really helpful 👍👍
This video is going to be really fruitfull for us Thanks alot
SELECT☆FROM AKASH SINGH
WHERE AAKASH SINGH="HELP";
* ye hota h bhai star ka mtlab :D
I bet everyone are watching this video just before exam 💀. Can anyone tell the answer of how to display all the information of IT teacher?
SELECT * FROM TEACHERS WHERE SUBJECT = 'IT'
Kisko kuch bi nhi samja school ne
Samajhne ki kosish hi nahi ki 😂😂😂
@@SoloLeveling-j5l halke me le liya isko😅😁😂
14:07 this same question came in my pre board 2 👍
Too underrated channel! Must say. Hope it achieve great height! ✨
Plz tell most important steps questions for IT 402
SIR STARTING ME MYSQL> NAHI KARNA?
And again jo sample hai uski sql queries me capital me nahi alphabets matlab queries small me likhi ha
THANKS... VERY BEAUTIFUL EXPLANATION
Handsome teacher ever ❤✨😌♾️❤️
17:49 we can Write '≥' Instead Of '>=' ?
Teacher with beauty with brain ❤😮
13:45 at this answer, descending order is not mentioned in the query. ??
But you'll have to write it if such questions come in the exam
Most underrated channel....💖🙏🏻
Yeah , true words 😩
Ultra legends are watching before 3 hours of exam😂
❤
😢
Before 2 hours 😂
Literally I have completed all my it syllabus by this channel and I'm confident enough that I'll score very good marks.... Thanks a lot Sir 😀❤️
Paper was easy
Hello sir we were not taught about syntax in school I always wanted it to be taught but today I am grateful to learn this new concept. Thank you sir.
all the best for your boards
Thank you for such an explanation sir.....
4:06 In our school we are not taught to put semi colon
Is it compulsory?? In my PC the query is coming without semi colon also
Btw nice explanation ☺️
Bro semi colon are compulsory in sql
It is essential
IT IS COMULSORY
You make last night preparation very easy... ❤️
BROHHH
IIT BOMBAY O MY GODDD!!!💀🥂🙂
Can we write it both as CLASS and Table class ?
Sir how we know that question is asking to write ORDER BY ....
IF THE QUESTIONS SAYS THESE TYPE OF WORD LIKE
ARRANGE SORT OR SIMPLY JB WO KHE IHNE SHI KRKE LGA DO
@@CHIRAGTHAKUR0 Thanks 👍
@@babybear_1111 KOI NA BHAI
ALL THE BEST FOR TOMMOROW 👍
Ye channel mje mere seniors ne recommend kia tha for IT... Ab mera 10 ho jaeeee then mai apne juniors ko ye channel recommend kruga😎💥🔥✨
*1st PYQ solution* 😄
a)
SELECT * FROM TEACHERS
WHERE SUBJECT = 'COMPUTER';
b)
SELECT * FROM TEACHERS
WHERE SALARY BETWEEN 20000 AND 35000;
c)
SELECT SUBJECT FROM TEACHERS
WHERE AGE > 40;
d)
SELECT NAME FROM TEACHERS
ORDER BY NAME;
*2nd PYQ solution*
1} a)There are 4 feilds and 4 Records.
2} i)
SELECT Sale_Id, Price FROM Sales
WHERE Discount > 1000;
ii)
SELECT * FROM Sales
ORDER BY Prod_Name;
iii)
SELECT Prod_Name, (Price - Discount) AS Sell_Price FROM Sales
@ARYAN Saharan Thanks, dude!
2 pyq
2 ka iii deducting the discount ka Kya hoga
@@KumariPrachiMahato [ SELECT Prod_Name, (Price - Discount) AS Sell_Price FROM Sales ], deduct karne ke liye brackets mei Price se Discount Subtract kar diya hai, thats all I can recall after a year 😅
for q,1 1. select*from teachers where teacher = 'computer' ;
2. select*from teachers where salary between 20000 and 35000 ;
3. select subject from teacher where age >40 ;
4. select name from teacher order by name ;
q.2 1. select sale_id , price from sales where discount >1000 ;
2. select * from sales order by prod_name ;
3. select prod_name , price-discount from sales as price-discount ;
In Q1 (1) you have written teacher = 'computer' ; but it should be subject = 'computer' ;
2.3) select prod_name , price-discount from sales as Sales_Price
Isnt this supposed to be the answer?
Sir at 5:50 , Stipend will be written as 'Stipend' or simply Stipend?
13:47 Don't we add desc in before the semi colon ?
But by the way it was great 💯💯
Who is watching one day before exam..😂😅
😂
Thankyou sir!
SELECT person FROM EARTH WHERE saviour = 'AKASH' ;
This man deserves a million subs🥰
sir can we write IS NULL for null 18:36 because in my book they have given this
Best teacher of IT I've ever seen⚡⚡⚡
Sir you are best teacher of it 402
Select * from Teachers where subject = 'Computer' ;
Select * from Teachers where salary between 20000 and 35000 ;
Select * from Teachers where age > 40 ;
Select* from Teachers Order by name ;
THANK YOU VERY MUCH SIR 💖💞
Koun koun ye vidoe last December 2024 me dekh raha h
Should we put semicolon after every line?
Yep its compulsory
At the end of every line we should put.
Sir ji I think in 00:13:47 there must be, (order by desc qty) by the way you are like a boon for student like me who had started it before 2 to 3 days 😅😅 thankuu sir 🤗🤗
🙂😁iitian broooo.... धनव्यवाद 🙏🌼❤️
12:11 Qty
Less than 300 kaha hai to < use hoga
Agar 'Less than 300 or equal to 300' kaha hota to
@@UFP_EDITZ acha ha bhai
Vo to between two values main hota h
a. SELECT * FROM TEACHERS
WHERE SUBJECT= 'IT';
b. SELECT * FROM TEACHERS
WHERE SALARY BETWEEN 20000 AND 35000;
c. SELECT SUBJECT FROM TEACHERS
WHERE AGE>40;
d. SELECT NAME FROM TEACHERS
ORDER BY NAME;
1. FEILDS- 4
RECORDS- 4
2. i. SELECT Sale_ID, Price FROM Sales
WHERE DISCOUNT >1000 ;
ii. SELECT * FROM Sales
ORDER BY Prod_Name;
Can you please give the answer from the last one.
thanks
@@sharanyareddy9690 Yes, 100% this is the Answer:
SELECT Prod_Name, Price - Discount AS Sales_Price FROM Sales;
Can we write like this for the second one , SELECT Prod_Name FROM Sales ORDER BY Prod_Name
@@Ben............ details hena to sab aajayega isliye *
But there is no subject of IT you have to right computer bro
@@seema4558 nvm that
thankyou Aakash....
Sir thank u today is my exam and i watched ur video 1hr before exam and it helped me to attain all sql query questions mark.
Sir when and how u completed ur syllabus for IITB
SELECT * FROM TEACHERS WHERE SUBJECT = 'IT' ;
Sir could you please please give the answers of both the hw questions since there ia a lot of confusion related to the questions like (iii) in 2nd question and (d) in 1st question. Please sir.
10:31 we must use Qty instead of quatity as mentioned???
Thank you so much sir!! We can give our best in this part❤
Could you also provide with a mock paper for IT before 13th March ?
Yes!!
like u bro for the facalities
who's here in 2025 ?☠
Finally I will again score good in IT 😁💙
.thank you 🔥
Sir didn't get last question of pyq 2 .....rest all were easy sir.....can you pls say in which class of yours have you explained that questions answer
Bhai 2 question me jo last part Tha na use descending order me set karna Tha apne by default code likha he jo ascending order me he arrange karega
Sir please tell the answer for the homework question no.2 .) 2. iii ??????
13:50 sir you forgot to write DESC.
hope I"ll also get into IIT like you and thankyou for your efforts man
Thank uu sir because of u i cleared my this topic thnks a lot ❤🙏🏻
1.) A ) SELECT * FROM TEACHERS
WHERE SUBJECT = 'COMPUTER' ;
B ) SELECT * FROM TEACHERS
WHERE SALARY BETWEEN 20000 to 35000 ;
C ) SELECT SUBJECT FROM TEACHERS
WHERE AGE > 40 ;
D ) SELECT * FROM TEACHERS
ORDER BY NAME ;
13:41 shouldn't we add DESC after Qty?
Yes I corrected it later in the video
Field names should be in double quotes right
😴
2021 ka (a)ka answer select * from TEACHERS
(b) select* salary from TEACHERS where salary between 20000 , 35000
(c) select* from TEACHERS where age > 40 years
(d) select * name from TEACHERS ordered by alphabetical order
Do we have to mention it as TABLE SALES or just SALES for the name of the table?
SIR I HAVE DOUBT IN TYPES OF VIRUS AND ADWARE , SPYWARE TOPIC PLEASE MAKE A SEPARATE VIDEO .
in 10:19, is it possible to write
SELECT * FROM SHOPS
wHERE QTY >100 AND
Yes
Sir can you please explain where to use Capital letters in query?
If I would have the ability to subscribe ten times or even twice I would do it to him.. thanks you so much sir 🙏
Just share it among your friends!
😂 nice!
@@aakashsingh.
do we put a semicolon at the end of every command or just specific commands?
Yes it's terminator
every
At 8.48 we have to insert new row ...so shouldn't we have to write insert into class rows
Sir don't we only have to write table name ...or we have to write table then table name
(a) SELECT * FROM TEACHERS
WHERE SUBJECT = 'COMPUTER';
(b) SELECT * FROM TEACHERS
WHERE SALARY BETWEEN 20000 TO 35000;
(c) SELECT SUBJECT, NAME FROM TEACHER
WHERE AGE > 40;
(d) SELECT NAME FROM TEACHERS
ORDER BY NAME ;
Thank you bhaiya it was very useful and I got to know how to do it ..
Bro aakash iit me automobile engineering ka package acha h kya
Bro we have to write all SQL answers in capital letters? 🙄
No you dont have to because it isn't necessary
Sir is it necessary to write in capital letters ???
Yes
Thank u soooooooooo much sir ....
Great explanation..🤌
thank you sir you helped me a lot for my exam but can you plz change background as it is hurting my eyes because of white plz can you change
Try to reduce the brightness
Please bring important questions for artificial intelligence 417
One mcq video is uploaded
Sir do we have to put equal to after where statement?
Dhanyawad a lot bhaiya 👊👊👊
Thank you sir you are giving us confidence to solve sql ❤️
Sir is it necessary to write the queries in capital letters?
Thankyousomuch sir>>
Nw my all doubt are cleared!!
Grateful tysm❤️
Sir telegram channel name kya hai
Find the link in community post
I have a doubt. When should we use star in SQL because you used them in some and didn't in some others??
Jab hume saare fields select karne hotey hai tab hum star use karte hai aur jab koii specefic column select karna hota hai tab hum example ke liye ( SELECT NAME ) isme humne siirf name select kiye hai tohh siirf name waali field dikhegi
Sir for display all products whose quantity in between 100 and 400
Can it be
Select*from shop where Qty=400>100
Where qty >400 and qty
Thankyou so much for this.
After this I don't have any doubt in SQL queries and can score full marks in this topic
Plzzz give tips to score full
Best video❤
sir aap ek mai Table likh rhe ho ek mai nhi esa kyu ?