[Top 11] SQL Interview Questions and Answers (Part 6)

[@Shaktiey]

Thanks

[@ThePrefectBA]

Thanks @Shakti Ram for recognizing our efforts and encouraging us with "Super Thanks" . Much appreciated !!

[@pritomdasradheshyam2154]

Thanks for the content, its very informative and hands on practical approach

[@ThePrefectBA]

Thanks a lot for the feedback Pritom. Much appreciated :)

[@poulamisarkar8133]

I am a big fan of all your vedios. Great stuff . Very helpful.

[@ThePrefectBA]

Thanks a lot Poulami , Very glad to hear your feedback.

[@traveltribethings1336]

You are doing such a great job man! Just one correction, in q number 6, in the output result table the name 'amount ' should be replaced with value as there is no such column named amount and we are retrieving value n not amount;
Just keep uploading more videos 😁😍

[@sunilnikam1496]

Thank you for all your videos. Your all videos are very informative and practical based. Also, your way of explanation is very nice....
Can you please help me to know any best course to learn the SQL including SQL stored procedures and all.

[@ThePrefectBA]

Thanks for the feedback ☺
Please refer to w3 schools /sql website which is the best way to learn sql

[@Shaktiey]

I really appreciate your effort. It's super helpful for people like me.
If possible please try to cover the Healthcare domain as well.

[@ThePrefectBA]

Thanks for your kinds words and your feedback. We don't have any team mate with health care domain expertise,hence would be difficult to make a video on healthcare domain. However, the BA techniques and concepts explained in our videos are applicable for all domains.

[@ameetpatra3260]

@theprefectba I hope in question number 7 , the name of the places inside the IN clause should be in single quote. Please confirm once.🙂

[@Ledesma184th]

The result on question 4 would not be the output of the query above. With the select statement, we are only retrieving name and value. The statement for the result below is not hugely different. See below:
SELECT name, value, city FROM orders
WHERE value > 500 AND city = ‘Seattle’;

[@shilpachaudhary5930]

yeah right, inthink he forgot to put it in slide thats why

[@kajoldave8122]

the 11th question was how do find the customer with minimum and maximum order value, and not just find the minimum, maximum order value :)

[@ndrey2676]

Great! Continue do it!
Ps. Syntax IN ('name1' , 'name2') for 7 example. Gl!

[@ThePrefectBA]

Thanks for the feedback . Thanks for correction on syntax.

[@traveltribethings1336]

Nice video but I don't understand why you dint also select city in 4th question .
It should be i guess : select name, value, city from orders
Where value > 500 And city = 'seattle'
Wherein in question number 5, you did select mode

[@Sam-ws1mu]

Agree

[@krishnagb1674]

Very good content

[@ThePrefectBA]

Glad you liked it

[@sandeepp6570]

Hi, thanks. This is informative. Can you please also cover topics like Joins etc..,?

[@ThePrefectBA]

Thanks Sandeep for your comment, yes we will be making another video on advanced SQL topics including joins. we will post it as one of our weekly videos

[@sandeepp6570]

@@ThePrefectBA great and thanks again for the videos. They r very helpful

[@BeccaL2016]

I have a first phone interview with amazon tomorrow morning!

[@ThePrefectBA]

All the best for the interview and I hope you get selected 🙂🙂👍

[@yasamnagaaravind8643]

Hey Becca...I have an interview with amazon in 4days could you please help me with your interview experience???

[@debadri]

solution to question 7: shouldn't Seattle and Baltimore be in quotes?

[@abbhinaw]

Need some video on advance sql queries. Tx in advance

[@ThePrefectBA]

Thanks Abhinav
We will post this video as one of our weekly videos. Pls stay tuned to our channel