1.Amazon SQL Interview Question And Answer|SQL Practice Exercises|Amazon Interview Question and Ans

This Video discussed the Amazon SQL interview questions which is asked in the interview. I discussed total ten real-time questions with details explanation. This video also very helpful to practice the Query based interview questions and answered for experience as well as freshers candidate.
-----------------------------------------------------------------------------------------------------------------
Real-time one-to-one training, Enroll Now: https://pandeyguruji.graphy.com/
Free training materials: https://t.me/pandeyguruji
For any queries contact me on social media:
Facebook: https://www.facebook.com/mpandeyguruji/
Instagram: https://www.instagram.com/pandey_guruji/
Linkedin: https://www.linkedin.com/in/mukesh-pandey-1a151634/
Q&A Session: https://t.me/+Mtp3M1b_nXc3YjE9
-------------------------------------------------------------------------------------------------------------------
SQL Tutorial for Beginners in Hindi: https://bit.ly/3CwfnGB
SQL Tutorial for Beginners in English: https://bit.ly/3qVI3GQ
SQL Live Training: https://bit.ly/3kXqOl1
Crack SQL Interview: https://bit.ly/3caxIyb
SQL Interview Questions: http://bit.ly/2CR6wCZ
Advance SQL Interview Questions: https://bit.ly/3HnMrnN
Career Guidance: https://bit.ly/3FffkRf
IT Technology News & Updates: https://bit.ly/3FeNQvc
--------------------------------------------------------------------------------------------------------------------
1.Given a table SELLERS with 3 columns SELLER_ID, COUNTRY, and JOINING_DATE, write a query to identify a number of sellers per country and order it in descending order of no. of sellers.
2.For the table in question 1 write a query to extract all sellers who joined on a Monday.
3. Given a table EMPLOYEE with two columns EMP_ID and SALARY, how can we extract alternate rows from a table?
4. Given a table EMPLOYEE with two columns EMP_ID and SALARY, extract the employees with the 3rd highest salary.
5. What is wrong with this SQL query? Correct it so it executes properly.
SELECT ID, YEAR(BILLINGDATE) BILLING YEAR
FROM INVOICES
WHERE BILLINGYEAR = 2010;
6. Assume a schema of EMP ( ID, NAME, DEPTID ), DEPT ( ID, NAME).
If there are 10 records in the EMP table and 5 records in the DEPT table, how many rows will be displayed in the result of the following SQL query:
SELECT * FROM EMP, DEPT
7. What is the difference between the Having and Where clause?
8. Consider a table EMPLOYEE with columns EMP_ID and SALARY with an unknown number of records. Write a query to extract the top 25% of the records based on salary?
9. Consider a table EMPLOYEE with columns EMP_ID, DEPT_NO, and SALARY. Write a query to extract all employees who have salaries higher than the avg. of their department.
10. Consider a table EMPLOYEE with columns EMP_ID and SALARY. Write a select query to output a rank against each record. The rank must be based on the salary(rank 1 for the highest salary)


#AmazonInterviewQuestions, #SQLInterviewQuestionsWithAnswered, #PandeyGuruji