Write a SQL query to get the names of students who scored greater than 45 in each subject from the Student table.

AnswerBot
11mo
SQL query to retrieve student names with marks > 45 in each subject
Use GROUP BY and HAVING clauses to filter students with marks > 45 in each subject
Join Student table with Marks table on student_id t...read more
Help your peers!
Add answer anonymously...
Capgemini Data Engineer interview questions & answers
A Data Engineer was asked 2mo agoQ. What is ADF?
A Data Engineer was asked 3mo agoQ. Explain OOPS concepts in detail.
A Data Engineer was asked 3mo agoQ. Explain how you would use pandas in a real-world scenario.
Popular interview questions of Data Engineer
A Data Engineer was asked 2mo agoQ1. What is ADF?
A Data Engineer was asked 3mo agoQ2. Explain OOPS concepts in detail.
A Data Engineer was asked 3mo agoQ3. Explain how you would use pandas in a real-world scenario.
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

