List for all students with a maximum final mark of more than 65, their surname and initials, sex (male/female using the CASE expression), highest final mark, average final mark, how many subjects the student has registered for and the date of birth exactly as listed below. Pay attention to the formatting of all the numbers and dates. Note that there are no extra spaces in front of the average final mark or in the display of the date. Ignore the blank lines between the rows. Student Information ----------------------------------------------------------------------------------- WHY PETOORS, a male student, is registered for 1 subject(s) with a highest final mark of 69 and an average of 69.0 and was born on 03 of December 1975 GM MKASI, a female student, is registered for 2 subject(s) with a highest final mark of 88 and an average of 75.0 and was born on 21 of May 1976 VM SMITH, a male student, is registered for 3 subject(s) with a highest final mark of 91 and an average of 72.3 and was born on 03 of December 1976 3 rows selected.
ua-cam.com/users/shortsB5sEzZlPS1c?feature=share
Ok
❤
You forget to mentioned
Select, orderby, groupby, Joins..
Hanji ye sbse jyada imp hai or ye yehi bhul Gaya
Order by to asc and desc ke liye hota hai na bhi
Select*from table order by city asc limit 2;
@@anujit6381Alphabet ka starting letter wala Top 2 ko chunega
Where 😅
Missed ALTER command DDL.
To alter the table
this video is just what i was looking for. thank you
It is very helpful thanks
So helpful sir ☺️ thankyou so much ❤
Wow 👌 thanks bhai
my friend said he would get me a techsuport job, but for that sql querries needed can this be learnt easily n quickly?
Yes, it's easy to learn in short span of time
Thanks a lot 😊
Nice
I don’t understand even one word 😢
I was you one week ago 😂
@@mrafam626 after then you??
😂😂
@@Pavi_2k after that he got his fathers sperm back
More voice use karna..ji...
You forgot the most imp function select
Hello! I'm trying learn SQL. Can I know if you can help?
Definitely I can help u
@@letscode7 Please let me know how I can start?
Thanks
Can anyone help me to learn sql through online classes?
Sure, I can help you
Please Make video for sql query writing.
Yaa sure, I'll bring complete playlist on MySQL this month only... Thank you for your response ☺️
if really do development and build some projects then u dont have memorise it honestly its timewaste to memorize build stuff
The most common thing 'Select' is missing bro..
And or gates h kya
how many commands in SQL languages total numbers are
There are so many .. but we use basic commands most
Select *from students where marks >90 and city="mumabi";
Bhol to bhii😂😢
Wehre is the limit and where function
Voice is not loud
Tq for the response.. it Will be fine next time
thoda or clearly explain.kre proper likhkr
Haan bilkul Bhai... Will work on this.
Thank you
❤
SELECT WHERE
Drop use for drop table not delete
Voice not clear
Thanks for your feedback, will make sure this issue will not be there in future videos
😊
Select, order, group?
Will cover in next video tq for your response 😊
Tysm
create ,insert ,alter ,update , joins , group by , order by ,truncate , in function , or and
where , groupy by , order by , having ???
Will cover in next video ta☺️
Where is Desc bro
What's the full meaning of SQL
U forgot the commit command
Sir tej bolo hmm kese ko nhe btaynge
Yes from the next time it will be fine 😁
May be in next month I'll bring complete series for DBMS.... Thanks for your response
Ithey nxt month loney nxt vedio loney cheyalsindi idi kuda.. 🤦♂️
❤❤❤❤❤
Thankuu
👍
Welcome
咖喱味的英语实在受不了😅
ْ
Alter, Rename
List for all students with a maximum final mark of more than 65, their surname and
initials, sex (male/female using the CASE expression), highest final mark, average
final mark, how many subjects the student has registered for and the date of birth
exactly as listed below. Pay attention to the formatting of all the numbers and dates.
Note that there are no extra spaces in front of the average final mark or in the display
of the date.
Ignore the blank lines between the rows.
Student Information
-----------------------------------------------------------------------------------
WHY PETOORS, a male student, is registered for 1 subject(s) with a highest final
mark of 69 and an average of 69.0 and was born on 03 of December 1975
GM MKASI, a female student, is registered for 2 subject(s) with a highest final
mark of 88 and an average of 75.0 and was born on 21 of May 1976
VM SMITH, a male student, is registered for 3 subject(s) with a highest final mark
of 91 and an average of 72.3 and was born on 03 of December 1976
3 rows selected.