AIYINGFrom AI Awareness to Accomplishment

Saturday, November 21, 2026

Gemini Complete for VTU Students #02 — Understand SQL Joins with Gemini

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

No comments:

Post a Comment

Accomplish with AI

Powered by Blogger.

Featured post

Did Claude Help Prove the Riemann Hypothesis? What Still Needs Checking

AIYING · PO Thinking Lab Did Claude Help Prove the Riemann Hypothesis? What Still Needs Checking By Ravindra Dastikop with ChatGP...

Search This Blog

List of blogs

Search This Blog

About

Translate

Instant Stories

Read in Your Language

Test

share this

ShareThis

Popular Posts

Continue exploring AIYING

Explore another case study, practical lab, or learning pathway.