Company: Amazon HackOn_30may
Difficulty: medium
A company recently conducted campus placements at a college, where students from various BTech and MTech branches participated. The company uses two separate tables to manage the data: the Btech table for BTech students and the Mtech table for MTech students. The Btech table includes columns for 'rollno', 'dept', 'backlog' and 'score'. The Mtech table contains columns for 'rollno', 'dept', 'backlog', 'btech_score' and 'score'. The company is currently focusing on students from the CE and IT branches in both BTech and MTech programs. The selection criteria are as follows: For Btech students: Must have scored more than 75 in the test. Must have no active backlog. For Mtech students: Must have scored more than 75 in the test. Must have no active backlog. Must have scored more than 75 in their Btech test. Write an SQL query to count the number of students who meet these criteria. Return the column field 'selected'. Input Format Btech: Column Name Data Type rollno INTEGER dept VARCHAR(50) b