SQL (Basic) Certification | Hackerrank Certifications

#C #HelloWorld #CS #C++ #Python #Programming #Unix #Linux #Hackerrank #CLanguage #CProgramming #Cbasics #printf #scanf #Certification #SQL #Mysql #MongoDB #include #stdio.h #vk #program #problem
Thanks for watching us ...
Dev19🖤

[@mohamedazharudeen1946]

select roll_number,name from student_information s inner join faculty_information f on s.advisor=f.employee_id where( f.gender='M' and f.salary>15000) or (f.gender='F' and f.salary>20000)

[@renielbencepo2300]

I did this but without the alias and it returns error I don't know why

[@mohamedazharudeen405]

​@@renielbencepo2300might be due to columns ambiguousness

[@DeepakV-jf3nb]

Actually the tables shld b joined based on common column. So they have mentioned for students table primary key is roll number but why hav they joined using advisor?

[@study_desk4231]

Nice bro :)

[@logeshkrishna726]

Bro I got an doubt Why are you using s.rollno and f.employee name.what does it mean ..?

[@kejditeranaj1312]

initilize the table where the column is selected

[@masellaniabdulaziz3485]

hi may I know why you assign s.advisor = f.employee_id? I am not clear about it.

[@mohitbokade2691]

just to join two table

[@kamaralam4798]

I AM BEGGINER ON SQL PLEASE LET ME KNOW WHY WE USE S. F.? WHAT IS THE USE OF IT. ANY REFRENCE FROM WHICH I CAN UNDERSTAND

[@kamaralam4798]

@@mohitbokade2691 I AM BEGGINER ON SQL PLEASE LET ME KNOW WHY WE USE S. F.? WHAT IS THE USE OF IT. ANY REFRENCE FROM WHICH I CAN UNDERSTAND

[@inderpanda]

@@kamaralam4798 It is used for renaming it as a shortcut
e.g - Students_information AS s

[@RiRi-jh5pf]

is there an issue with my query:
select roll_number, name from student_information where advisor in
(select employee_ID from employee_information where gender='M' and salary > 15000
union
select employee_ID from employee_information where gender='F' and salary > 20000)

[@mohammadsohail1303]

All of us having same questions or different

[@amitdwivedi5332]

Why we are not using Inner Join condition?

[@dipeshmandanka]

There are two ways to write joins
1. using a theta format ( used in this video ) and
2. using join format

[@kamaralam4798]

@@dipeshmandanka I AM BEGGINER ON SQL PLEASE LET ME KNOW WHY WE USE S. F.? WHAT IS THE USE OF IT. ANY REFRENCE FROM WHICH I CAN UNDERSTAND

[@farazahmad4002]

@@kamaralam4798 is known as Aliase in SQL to provide the temporary name

[@mohitbokade2691]

Is any one gave this test and those got the same question

[@darksoul90537]

i got 1 question student one the same... but 2nd question was combining name and country mobile code numbers.

[@shikhabharti7436]

Is there any charges for this exam??

[@dev.19.community]

No

[@zebra2218]

my dear - learn first properly and then make a video. sincere advise

[@gdtotshared-jk4uo]

Just because he didn't solved them using the method you know doesn't mean he hasn't learnt.
Why didn't I found the videos on your channel since you've "learnt" so much?