AIYING · Gemini Complete for VTU Students · Episode #02
How to Use Gemini to Understand a Topic You’re Stuck On
You run an SQL query and Asha disappears from the result. Her record is still in the Students table. Where did she go? Use this DBMS example to learn how to ask Gemini for an explanation you can check and explain yourself.
Think · Predict the result
Students (id, name): (1, Asha), (2, Ravi).
Enrolments (student_id, course): (2, DBMS).
Match Students.id to Enrolments.student_id. Before opening Gemini, predict which names an INNER JOIN will return and write down why. Identify the point you are stuck on.
Ask · Request a row-by-row explanation
I’m learning SQL joins. My prediction is [write it here], and I’m stuck on [describe the exact point].
Students (id, name): (1, Asha), (2, Ravi).
Enrolments (student_id, course): (2, DBMS).
Join on Students.id = Enrolments.student_id. Compare INNER JOIN with LEFT JOIN, with Students on the left. For each student, show whether a match exists and what appears in the result. Then give me one variation to solve. Wait for my prediction before giving feedback.
Judge · Check the explanation by hand
- INNER JOIN: Ravi matches the enrolment with student ID 2. The query returns (Ravi, DBMS). Asha has no matching enrolment, so the result contains no row for her.
- LEFT JOIN: The result contains (Asha, NULL) and (Ravi, DBMS). Asha’s row comes from Students. NULL is the missing course value from the unmatched Enrolments side.
Check the matching pairs yourself. Then add a second enrolment for Ravi, (2, Networks). Predict both results before checking. INNER JOIN now returns two rows for Ravi. LEFT JOIN returns those rows plus (Asha, NULL). Without ORDER BY, compare which rows appear rather than their order.
Accomplish · Explain it from memory
Close the chat. Explain to a classmate why Asha appears in only one result and why Ravi appears twice after the change. Then ask Gemini for a fresh example. Predict the output, check it, and save one sentence correcting your original misunderstanding.
From college to work · Investigate a report
As an intern, you notice a report omits customers who have placed no orders. Use two fictional records to reproduce what you see. Ask Gemini to trace the join, check the result yourself, and confirm with a teammate whether the report should include customers with zero orders. Share the example, expected output, and confirmed requirement.
Next episode: Turn lecture notes into a self-test.
AIYING · Accomplishing with AI · dastikop.blogspot.com


