IBC Quiz #220
04/09/2026
Mohith.R
Class 7
Karnataka Public School
Atharv Pandey
Class 4
Sri ram public school
Shovan M B
Class 7
Poorna Vikasa Vidyalaya
Hema G S
Class 7
Sri Vasavi Vidya samsthe sira
Lokjeeth PN
Class 7
Vidya jyothi school
Hitesh .B
Class 4
Sri sharada english high school
Arohi Gupta
Class 4
St Thomas convent hr. Sec. School begumganj
Muskan
Class 4
Govt excellence scholl
Thaswikaa.S
Class 7
Jnana Jyoti public school
Chahana Chelsea
Class 7
Swargarani school 🏫🌌
Note: Quiz prizes will be awarded to ten randomly selected students who submit correct answers before the deadline. Winners will be declared on the website and the weekly newsletter.
.png&w=1080&q=75)
Previous Week Quizzes
IBC Quiz #220
September 04, 2026
Kim is a data analyst who works with data every day. Her job is to retrieve useful information from databases so that managers can make better decisions.
A company can have millions of records stored across multiple tables. These tables may contain information about employees, customers, products, sales, salaries, departments, and much more. The table Kim currently working has the below-mentioned columns. employee_id, first_name, last_name, department_id, gender, date_of_birth, email, phone, hire_date, job_id, manager_id, employment_type, status.
Your task :
Kim's manager asks her to prepare a report of the active employees in the company.
The manager wants the report to show:
-
Employment type
-
Department ID
-
Employee Count
The employee count should be calculated based on the employee ID for each employment_type and department combination.
After calculating the employee count, she wants the results arranged from the highest employee count to the lowest employee count.
The manager has already reviewed the first 2 results and now wants to see only the 3rd result.
Notes: SQL clauses need to be arranged in the below mentioned order
SELECT → FROM → WHERE → GROUP BY → HAVING → ORDER BY → LIMIT → OFFSET
Kim is a data analyst who works with data every day. Her job is to retrieve useful information from databases so that managers can make better decisions.
A company can have millions of records stored across multiple tables. These tables may contain information about employees, customers, products, sales, salaries, departments, and much more. The table Kim is currently working on has the columns below. employee_id, first_name, last_name, department_id, gender, date_of_birth, email, phone, hire_date, job_id, manager_id, employment_type, status.
Kim is helping the HR manager prepare a list of employees who are currently working in the company.
The manager wants to review employees with an active status. She wants the report to show:
-
Employee ID
-
First Name
-
Department name
She wants the employees arranged department-wise, starting with the department having the smaller department ID. Within each department, employees should be arranged according to their employee ID, from smallest to largest.
The manager has already reviewed the first 3 records and now wants to see the next 5 records.
Notes: SQL clauses need to be arranged in the following order:
SELECT → FROM → WHERE → GROUP BY → HAVING → ORDER BY → LIMIT → OFFSET
Your Task:
What SQL query should Kim use to generate the report requested by the HR manager?
IBC Quiz #219
August 28, 2026
A robotic factory has a large automated conveyor machine that uses two circular pulleys connected by a crossed belt. The belt has suddenly snapped, and the engineer needs to replace it with a new one.
The larger pulley has a radius of 70 cm, and the smaller pulley has a radius of 40 cm. The two pulleys are mounted on a machine frame. The distance from the centre of the larger pulley to one edge of the frame is 90 cm, while the distance from the centre of the smaller pulley to the opposite edge is 70 cm. The length of the frame is 360 cm.
To make the second pulley rotate in the opposite direction, the engineer must use a crossed belt. The straight portions of this belt form transverse common tangents to the two pulleys.
The engineer has asked your team to calculate the length of one straight portion of the belt before cutting the new belt.
Can you help the engineer find the required length?
đź’ˇ Hint: The length L of the transverse common tangent is equal to the square root of the distance between the centres squared, minus the sum of the two radii squared
A robotic factory has a large automated conveyor machine that uses two circular pulleys connected by a crossed belt. The belt has suddenly snapped, and the engineer needs to replace it with a new one.
The larger pulley has a radius of 80 cm, and the smaller pulley has a radius of 50 cm. The centres of the two pulleys are 200 cm apart.
To make the second pulley rotate in the opposite direction, the engineer must use a crossed belt. The straight portions of this belt form transverse common tangents to the two pulleys.
The engineer has asked your team to calculate the length of one straight portion of the belt before cutting the new belt.
Can you help the engineer find the required length?
Hint: The length L of the transverse common tangent is equal to the square root of the distance between the centres squared, minus the sum of the two radii squared
