Asked in Deloitte
There is a table of students having a column named 'status' with values 'pass' or 'fail'. Write the syntax to show the output as '60 pass' and '40 fail'.
AnswerBot
8mo
Use SQL query to display 60 pass and 40 fail from a table of students.
Use SELECT statement with COUNT function to count the number of pass and fail statuses.
Use WHERE clause to filter out pass and fai...read more
Help your peers!
Add answer anonymously...
Top Automation Tester Interview Questions Asked at Deloitte
Q. What is the difference between hard assert and soft assert?
Q. There is a table of students having a column named 'status' with values 'pass' o...read more
Q. There are n number of links having the text selenium. Write the syntax to count ...read more
Interview Questions Asked to Automation Tester at Other Companies
Top Skill-Based Questions for Deloitte Automation Tester
Software Development Interview Questions and Answers
250 Questions
Software Testing Interview Questions and Answers
250 Questions
Web Development Interview Questions and Answers
250 Questions
Java Interview Questions and Answers
250 Questions
Algorithms Interview Questions and Answers
250 Questions
Stay ahead in your career. Get AmbitionBox app
Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+
Reviews
10L+
Interviews
4 Cr+
Salaries
1.5 Cr+
Users
Contribute to help millions
AmbitionBox Awards
Get AmbitionBox app
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2025 Info Edge (India) Ltd.
Follow Us
